Hi,
I am trying to write a code that copies an active cell 12 columns out, without specifying the 12th column.
Capture.PNG
The highlighted rows are an example of what I am looking for.
I was thinking of doing something like:
For Each cell in Range("M:Z")
**somehow auto-fill each cell containing a value in the range to 12 cells to the right.
Anything is helpful thank you!
Untested, but try:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you, I keep getting an error message on the second line.
oops:
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Or, with multiple contiguous cells in the same column:
Please Login or Register to view this content.
Thank you this was very helpful! I am having trouble applying this to the first cell in each row in the range M:X. Do you have an idea of how I can do this so it will look like the rows I highlighted in the first image, but for every first cell within each row?
You saidand that's what the code I provided does.I am trying to write a code that copies an active cell 12 columns out, without specifying the 12th column.
I'm not sure what you are asking for now. You only highlighted a couple of rows ... and you refer to an "active cell" which implies that you have selected a cell before running the macro.
Given that you have start and end dates, why don’t you just use a formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks