How to write a macro that searches across row one for a comment in a cell containing #LAST_COL selecting the cell before that
and down the first column for a #LAST_ROW and selecting the cell before that for a copy?
Row 38662 contained the #LAST_ROW comment
Column CQ contained the #LAST_COL comment
Starting point will always be cell A5
Using developer tool and recording macro ended up with
Range("A5:CP38661").Select
Selection.Copy
How about:
?
Please Login or Register to view this content.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Run-time error '1004':
Method 'Range' of object '_Global' failed
I used #LAST_COLUMN rather than #LAST_COL - my mistake, little details. Try again without "UMN"
Close, macro copied everythingI need it the macro to begin copy from A5 (first 4 rows contain directions) and then up the last row and last column but excluding them (these rows/columns are borders).
Third time's a charm...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks