method range of object _worksheet failed

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

.Rows(ContRow).EntireRow.Delete

Changed status to publish
0
Sen  (anonymous) 0 Comments

Instead of dot use thia symbol 

Changed status to publish
Write your answer.