How do i start a new line of code if i exceed the max. # of characters?
here is my code: i did to continue the Range to a new line.
Please Login or Register to view this content.
How do i start a new line of code if i exceed the max. # of characters?
here is my code: i did to continue the Range to a new line.
Please Login or Register to view this content.
Last edited by adamheon; 02-19-2014 at 11:36 AM.
If this range is static you could create a named range and use that....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Another solution something like
orPlease Login or Register to view this content.
Note that you don't have to select the rangePlease Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
I'm sorry I added the wrong code....could you show how it should look with this code?
Please Login or Register to view this content.
Something like this
Please Login or Register to view this content.
However my personal preference would be to declare a variable of type range that will hold reference to the range in question
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks