method range of object _worksheet failed

143 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
Sen  (anonymous) 0 Comments

Instead of dot use thia symbol 

Changed status to publish
0
dida (anonymous) 0 Comments

.Rows(ContRow).EntireRow.Delete

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
0
POD (anonymous) 0 Comments

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

Changed status to publish
Write your answer.