Sometimes Intellisense, sometimes not

[Alan]

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 are:
VB for Applics
MS XL 8 Obj Lib
OLE Automation
MS Forms 2 Obj Lib
MS Office 8 Obj Lib

Regards,
Alan

 

[Steve Garman]

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

 

[AlanDavidson]

Thanks Steve. That works fine.

Regards,
Ala