Looks good to me...
This procedures works fine inside a standard module:
Sub test()
Dim rg As Range
Set rg = Worksheets(1).Range("B1:B50")
rg.Select
End Sub
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Jess" wrote in message
...
Hi!
I am new to programming in Excel 2000 and have the following problem.
if I type the following code
dim rg as range
Set rg = Worksheets(1).Range("B1:B50")
when I type
"rg."
no property list pops up and rg is not a variant
This is happening with many other properties and objects
What is going on?