Sometimes Intellisense, sometimes not
 

I'm using Excel 97.

In the following lines, Intellisense only works
for "Range" and "Application". Is there any way that I
can force Intellisense to work in all cases?

---------
Columns("C:C").Select
Selection.Copy
Range("C3").Select
Application.CutCopyMode = False
ActiveSheet.Paste
---------

My references a
VB for Applics
MS XL 8 Obj Lib
OLE Automation
MS Forms 2 Obj Lib
MS Office 8 Obj Lib

Regards,
Alan

Sometimes Intellisense, sometimes not
 

Sub test()
Dim rng As Range, rng2 As Range, ws As Worksheet
Set rng = Columns("C:C")
rng.Select
rng.Copy
Set rng2 = Range("C3")
rng2.Select
Set ws = ActiveSheet
ws.Paste
End Sub


Alan wrote:
I'm using Excel 97.

In the following lines, Intellisense only works
for "Range" and "Application". Is there any way that I
can force Intellisense to work in all cases?

---------
Columns("C:C").Select
Selection.Copy
Range("C3").Select
Application.CutCopyMode = False
ActiveSheet.Paste
---------

My references a
VB for Applics
MS XL 8 Obj Lib
OLE Automation
MS Forms 2 Obj Lib
MS Office 8 Obj Lib

Regards,
Alan

Sometimes Intellisense, sometimes not
 

Thanks Steve. That works fine.

Regards,
Ala

--
Message posted from http://www.ExcelForum.com