Excel and VBA programming question

oblivious69 · 01-09-2006, 03:12 PM

I need to write a quick dirty excel sheet with some vba to load some data...but I keep getting an error. Here is what I've done

------
Dim locType As String
.
.
.
Set locType = Worksheets("whateverwkst").Cells(locrow, loccol + 1).Value
------

When I run it, I get an error with "locType =" highlighted saying compile error: object required. What am I missing?

zikhermm · 01-09-2006, 04:13 PM

you're getting the error because by using 'set' its expecting an object.

what you have is correct, just take out the 'set' keyword. Also maybe you want cells(row,col).text, rather than cells(row,col).value?

your call though

oblivious69 · 01-10-2006, 10:22 AM

that was it, thanks!