I know there are other ways to set a range in excel
Range("A1:A10")
Range(Cells(1,1),Cells(10,1))
Application.Range(Cells(1,1),Cells(10,1))
etc
But I want to know how to set a range with a variable inside it, because I want to use a for loop like this:
Any help is appreciated, thnks
Please Login or Register to view this content.
How aboutPlease Login or Register to view this content.
use an offsetPlease Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
If the requirement is to sum the rows 2:5 moving across the five columns E:I at each iteration of the loop then your code works as per #1
It could be marginally shorter.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Only if Sheet1 is the active sheetIf the requirement is to sum the rows 2:5 moving across the five columns E:I at each iteration of the loop then your code works as per #1
It could be marginally shorter.Please Login or Register to view this content.
Deleted...although a result ... nothing to do with requirement...
Last edited by Sintek; 11-20-2021 at 07:12 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
...which could be overcome by fully qualifying the sheet in the code...Originally Posted by Fluff13
Only if Sheet1 is the active sheet
Agreed...which could be overcome by fully qualifying the sheet in the code...
...........
Non looping solution...
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