![]() ![]() in Excel 2010 - this would be row 1048576. If I start at A1 and hit Control down arrow - that takes me to the last row of data, then you could just down arrow once more or enter down 1 and you are ready to paste a new range again.īut, if this is the first iteration of the copy paste transpose, a copy down arrow goes all the way to the bottom row. Now, I have 2 or maybe 4 or 6 rows of data pasted on the 2nd sheet. I can then just delete the first blank row (which was my placeholder). So, on the first iteration if I highlight row 2 and then hit copy/paste/transpose, that works. The 2nd ws will initially only have column ![]() ![]() I have a 3 column dynamic named range (it will expand by 2 columns over time, the first column is a placeholder to keep it dynamic) on a ws which I want to then copy paste transpose into rows on another worksheet. This should be fairly simple for the advanced vba user. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |