| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting range value to a variable
Todd,
Get rid of the Set keyword. It is only used when assigning an object to an object variable. Since you have declared desc as a String, and you are using the Value property of the range, you don't need and are not allowed to use Set. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd" wrote in message ... Hi all, I'm trying to set a range value to a variable with the following code: Dim desc As String Set desc = Range("D9").Value I keep getting an "Object Required" error and can't for the life of me figure it out. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting a string variable as the file name | Excel Discussion (Misc queries) | |||
| Setting up variable summary sheet. | Excel Discussion (Misc queries) | |||
| Setting variable names in code | Excel Programming | |||
| Setting a variable print area | Excel Programming | |||
| Setting up a variable print range | Excel Programming | |||
Threaded Mode
