Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range type variable oddness
I wish to do this:
Dim TempData As Worksheet Dim SearchRange As Range Set TempData = ThisWorkbook.Worksheets("Temp Data") Set SearchRange = TempData.Range(Cells(1, 1), Cells(1, 26)) The code currently comes up with an error message saying the range method has failed. I do need to declare tempdata and searchrange separately cos I will be changing the searchrange in a "for, next" loop. I always thought that range was a property of worksheets not a method. Bit confused and although I have tried many different variations I can't get one to work. Any reponse would be, as always, much appreciated. Nick Shinkins |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Trouble with variable type | Excel Programming | |||
efine the data type of a variable | Excel Programming | |||
type variable as argument of a sub | Excel Programming | |||
Variable Type - help me to solve this | Excel Programming |