Erik -Deleting row cont.

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Erik, thanks that worked with my If statements testin if
the input was greater than 6 and =6.

How would I test (If statement) if the first cell in (user
InputRow) "RName" row is blank? I had:

If Cells(RName,0).Value ="" Then
MsgBox "Row is blank"

but this errors w/message: Run-time error 1004:
Application defined or object-defined error.
 
Dan,

Change the 0 to a 1. You can't select column zero in the Cells property:

If Cells(RName,1).Value ="" Then

hth,

Doug Glancy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with exported text 5
Deleting a User Input Row 4
Arrays and Loops 3
With statement help 2
Run-time Error '1004' 1
Error 1004 while getting Cell Name 2
Return last row no. of column with blanks at top 7
runtime 1004 error on deleting rows with blank cells 5

Back
Top