Error 91 - I'm missing something

[toolman_dustin]

I'm new to Macro's but very experienced with Excel .

I wrote the following macro to look down column "V", find a text character "X".
Copy and "paste special value" the "X" and the two columns to the right of the "X".
Then, come back, erase the "X" and move the "X" one row below it's last location.

Then, the macro moves to column "R" to find and erase an "X" in that column.

The "error 91" occurs while trying to find the "X" in column "R".


I'm sure I've left some "definition" out but I need some help.

Thanks,
toolman_dustin

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[Norie]

If the X has just been cleared how is Find going to, well, find it?

[toolman_dustin]

The first "X" deleted was in column "V".

The error is occurring while trying to delete an "X" in column "R".

[Norie]

You aren't specifying where to search, just using Selection.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[toolman_dustin]

The attached example should help. thanks

[Norie]

When I copy the posted code into the workbook you attached and then run it the error is right at the start, here.

Please Login or Register  to view this content.

When I look at column V there's no data, all the data seems to be within column B to I and K to R.

[toolman_dustin]

Here is a slice of the actual spreadsheet.

The macro will function. It performs correctly the first time you run it, It fails the second time you run it.

thanks, Dustin

[toolman_dustin]

I found the error. Thanks to your request for a working example.

The search in column "R" was supposed to run from row 34 to row 119.

I was placing an "X" in column R beyond row 60 (which is how it is coded). So the error occurred when the search for "X" failed.

Thanks for taking the time to help.

Dustin

[toolman_dustin]

we got this solved. thanks

[Norie]

Dustin

Glad you solved it.

Remember and mark the thread solved - there's a button for doing that apparently, not sure where though.

[Solus Rankin]

I think it might be in the 'thread tools' link at the top of the thread