Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm taking this tutorial http://homepages.ius.edu/WCLANG/vbnotes/vbex2.htm and cannot run the macro for the "Hello World!" procedure. I get a compile error with when i try to run this: - the yellow cursor pointing at the defined "Sub Hello World()" - "CurrentSheet =" is selected Here is the code from my sheet1 object: Sub HelloWorld() Set CurrentSheet = Application.ActiveSheet CurrentSheet.Cells(2, 5) = "Hello World!" End Sub Any help would be appreciated. I am running Excel97 (I know, I know, its old) -- TIA AFJr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tutorial | Charts and Charting in Excel | |||
Try this new excel tutorial | Links and Linking in Excel | |||
VBA tutorial | Excel Programming | |||
VBA tutorial | Excel Programming | |||
Tutorial Available | Excel Programming |