View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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?