method range of object _worksheet failed

[rersel]

vba error.PNG

can someone help me with my problem.

[torachan]

Your 'FirstRow' is returning a negative number.

[rersel]

Your 'FirstRow' is returning a negative number.

Hi torachan, can you help me modify my existing formula?

[rersel]

Attachment 645006

i guess the negative number is cause by image above. how is the cell B2 an empty cell well in fact there's a value in it.

[torachan]

No attachment - pictures are no use - I have not a crystal ball - guesswork wastes time - workbook is needed.


Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.