I am trying create an Excell workbook that will manage some data I have imported from an Access database.
This may sound crazy, but I can't get the VBA code to select a sheet, and then select a range.
Here is the code:
the error is:
"Wrong number of arguments or invalid property assignment"
This is on a brand new workbook. Data has nothing to do with this code, at this stage I just want to select a cell on another sheet. What gives??????????????
Jedel
This may sound crazy, but I can't get the VBA code to select a sheet, and then select a range.
Here is the code:
Code:
Sheets("Sheet1").Activate
range("A2").Select
the error is:
"Wrong number of arguments or invalid property assignment"
This is on a brand new workbook. Data has nothing to do with this code, at this stage I just want to select a cell on another sheet. What gives??????????????
Jedel