Make macro independent of position

Hello Call,

This line of code is responsible for taking you to "C31"...

Please Login or Register  to view this content.

I am trying to figure out what you really want to do, and this is how it sounds:

You have a formula in a cell. You want to paste the result of that formula in the cell immediately to the right. That value is a cell reference. Then you want to go to whatever cell that reference indicates. Is that right?

Your code suffers from macro recorder bloat. Excel's macro recorder records every step of every action, because it doesn't know what you're going to do next. Try this:

Please Login or Register  to view this content.

If you don't really need to copy the value to the cell to the right, and you're only doing that so you could copy the value from there to be able to paste it to a GoTo, then your code collapses to this:

Please Login or Register  to view this content.

Thanks for your replies

Oh, yes. I'm sorry. Reading my post back now I see I've made myself not clear at all.


I have two worksheets I'd like to match up the rows of. (Add rows in the shorter list)

To do that I've set up a 3rd worksheets which compares them. When the comparison returns FALSE, I'd like to get the current row, switch to the relevant worksheet, and go to the relevant row.

So, I've added a column with =row()... and for the rest see my first post.


I've tried your code a bit. But I haven't yet gotten it to work. I also need to go to a different worksheet

Please Login or Register  to view this content.

------------------------------------------------------------------------------------
EDIT1:

By the way, I am able to compare the two worksheet from a technique someone on this forum taught me a while ago: =INDIRECT("'[Test.xls]Sheet 1'!D"&ROW())

The third worksheet is basically two columns that reference the two worksheets via this INDIRECT method, and a third column that has =EXACT(A3,B3) (comparing the two). I've now added the =ROW() column.

The INDIRECT method references the cells I need to jump to. Maybe that can be part of an easy solution?

--------------------------------------------------------------------------------------
EDIT2:

When pasting into the GoTo dialogue box, Excel pastes the value, so I can simplify this faulty code to:

Please Login or Register  to view this content.

I've tried using 6StringJazzer's code, but my VBA skills are nonexistent.