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