method range of object _worksheet failed

147 views
0 Comments

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!

Changed status to publish
0
Dia (anonymous) 0 Comments

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

Changed status to publish
You are viewing 1 out of 1 answers, click here to view all answers.
Write your answer.