Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I keep getting a run time error when this macro gets to y=ActiveCell:
Any help would be appreciated. 40 ActiveCell.Offset(1, 4).Select Do Until x 0 ActiveCell = 0 ActiveCell.Offset(-1, 0).Select y = ActiveCell.Select Do Until ActiveCell.EntireRow.Hidden = False If ActiveCell.EntireRow.Hidden = True Then ActiveCell.Offset(-1, 0).Select End If Loop y = ActiveCell If -x < y Then ActiveCell = y + x End If x = x + y Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reasons for "Run-time error '13':Type mismatch"? | Excel Programming | |||
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch" | Excel Programming | |||
Run-time Error "13" - File Type Mismatch | Excel Programming | |||
Help with Run-time error: "Type Mismatch" | Excel Programming |