Hi again All,
I'm just trying to get my head around something here! My intention is to loop through cel1 To cel5 for example so that I can set a range using the union of these cells if they are not nothing (Something). The problem being that I can't seem to use arrays i.e cel(1) to cel(5) because I am using them in their own For Each.. Next Loops. Anyone got a way around this?
Many thanks!
Please Login or Register to view this content.
ARowbot
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
You can't use syntax like this to refer to variables.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I understand that hence why it is in red! I was after a way around it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks