Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I thought that as well, but nothing happens. The contents of the array
is definately 8 as an integer (different numbers, nothing happens either). And yes the code does execute as I have used break points etc but no errors and no deleting actually occurs...grrrr This is a bigger section of the code if it helps: If ((Selection.Value < "") And (sheetmemo(i) = "")) Then Rows(sheetcell(i)).Delete sheetmemo(i) = Selection.Value ActiveCell.Offset(0, -5).Select sheetarray(i) = Selection.Value sheetcell(i) = ActiveCell.Row ActiveCell.Offset(1, 0).Select ignore = 1 Exit For End If Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |