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
or![]()
Please Login or Register to view this content.
Note that you don't have to select the range![]()
Please 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