| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vbscript to open worksheet, insert data on first open cell....HELP.....
GBPackerBacker wrote:
.. look into the last cell of Column A I think you want: Dim iRow To get the row of the last used cell in column A: iRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row To get the row of the last used cell in the worksheet: iRow = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row and you can add 1 to get the next row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' | Excel Worksheet Functions | |||
| Delete Insert Worksheet on Open/Reset on Close | Excel Programming | |||
| Save and Close all Open Workbooks using VBScript | Excel Programming | |||
| Catching an Open Excel File with VBScript | Excel Programming | |||
| open Excel workbook using vbscript | Excel Programming | |||
Hybrid Mode
