how do u declare a range of cells... this is what i hav done but its wrong...
Dim title As Range
title = range("A1:D1")
how r u ment to do it???
how do u declare a range of cells... this is what i hav done but its wrong...
Dim title As Range
title = range("A1:D1")
how r u ment to do it???
It depends upon what you want to do. If you want to store a created range in a variable called title, then use:
on the other hand, if you want to store the values in the range as a Variant Array in the variable title use:Please Login or Register to view this content.
Please Login or Register to view this content.
HTH
Myles
...constantly looking for the smoother pebble while the whole ocean of truth lies before me.
cool cheers m8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks