Hi There Please help, trying to delete a row on a contact management spreadsheet, have followed instructions but get the attached error when clicking on delete button.( Method ‘Range’ Range of object’_Worksheet failed) If i hover the mouse over the ContRow I do get a row number ContRow = 427. Not sure where i have gone wrong. Thanks!
Thanks For the add. I need some help. I am Following along with the Create Horizontal AND Vertical Tabs video on you tube. I get to the point to where you run the first macro and i get a Run-Time error 1004, Method ‘range’ of object’_Worksheet Failed. I hit debug and then this line is highlighted in yellow.
.Range(FirstRow & “:” & FirstRow + 19).EntireRow.Hidden = False
Hover your mouse over the variables and check their values. Tgen check the specific cell referenced. Please also watch the corresponding video on data mapping