Missing Paramenter List
 

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?

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?

Missing Paramenter List
 

Rob,

this is not what I am asking for. I just want to know why the property list
for the rg object is not automatically displayed when I type "rg."

These two sentences make rg an range-type object

Dim rg As Range
Set rg = Worksheets(1).Range("B1:B50")

Therefore, should display automacally the property list for the range object
when I type "rg."

Thanks



"Rob van Gelder" wrote:

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?

Missing Paramenter List
 

Sorry - I should have been clearer with my response.

With the code I replied with, when I typed the fullstop in rg.Select,
Intellisense displayed the property list.

I don't think it's your code, but something external to that code block
interfering.
Try to put that code block into a new workbook and see what happens.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jess" wrote in message
...
Rob,

this is not what I am asking for. I just want to know why the property
list
for the rg object is not automatically displayed when I type "rg."

These two sentences make rg an range-type object

Dim rg As Range
Set rg = Worksheets(1).Range("B1:B50")

Therefore, should display automacally the property list for the range
object
when I type "rg."

Thanks



"Rob van Gelder" wrote:

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?

Missing Paramenter List
 

Jess,

Do you have it enabled?

In VBA, go to the ToolsOptions, then on the Editor tab. There, check that
"Auto Data Tips" is checked.


--
HTH

-------

Bob Phillips
"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?