LinkBack URL
About LinkBacks
You don't need to select ranges in VBA as a rule.
If the range has empty rows & columns around it you could use CurrentRegion
Dim rng As Range Set rng = ActiveSheet.Range(Cells(2, 8), Cells(Rows.Count, 13).End(xlUp)) 'e.g rng.Copy
You don't need to select ranges in VBA as a rule.
If the range has empty rows & columns around it you could use CurrentRegionDim rng As Range Set rng = ActiveSheet.Range(Cells(2, 8), Cells(Rows.Count, 13).End(xlUp)) 'e.g rng.Copy
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you for this - I haven't yet got my head round "dim" and all that though! Can you please advise what the numbers (2, 8 and 13) apply to?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks