Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes Intellisense, sometimes not
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Intellisense | Excel Worksheet Functions | |||
Intellisense | Excel Worksheet Functions |