View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Missing Paramenter List

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?