If I am on cell C5 for example, what line in my macro will make Excel select the range that is the 4 cells next to it.
On cell C5, I want it to select the range C5:G5 but do so dynamically so I can have it triggered by a number as it loops through a report?
Good afternoon ChrisF79
There's probably a much faster, more efficient way of looping through cells than selecting each one, performing the action and moving on to the next, but in the absence of any other info, I'll just provide an answer to your question :
HTH
Please Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
As dominic said, there's probably a more efficient way to parse through your data and do what you need, but as an alternative to dominic's line of code, the following might be a bit easier to work with:
The row and column resize values (1 & 5 respectively) can be assigned to variables or cell values, too.Please Login or Register to view this content.
Another couple of ways.
Please Login or Register to view this content.VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks