Is there a way to declare variables in excel? I have a simple copy and paste macro here.
Please Login or Register to view this content.
I defined my range in the loop as RangeOne and RangeTwo so it becomes something like this but it is giving me an error. I know I can name cells out of the editor but is there another way?
Please Login or Register to view this content.
Last edited by hei.so; 01-16-2018 at 09:27 AM.
Range is an object. So you need to "Set" variable.
Ex.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Do I have to use rng? I use rangeOne and rangeTwo because I have two different ranges. But this is still giving me error 1004.
Please Login or Register to view this content.
Oh, should have looked at your Range argument closer. You can't use "BG#", "BN#" in range.
Should be.. Range("BG" & i & ":BN" & i)
Should these 2 lines of code be inside the loop?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Still doesn't work. Not sure what I'm doing wrong but at this point, I will look at it later for learning purposes. The code works with not declaring variables.Originally Posted by CK76
I entered it in the For loop but for some reason it messes up other parts of my code. I'll leave it for now.Should these 2 lines of code be inside the loop?
Please Login or Register to view this content.
Thanks to you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks