VBA - button to move to another sheet to same cell

**baz0912** · 05-09-2008, 07:33 AM

Hi, I'm trying to create a button on 2 sheets so when I click the button, it will move to that sheet with the same cell reference, i.e. cell A30 on sheet 1 will move to A30 on sheet 2 and vice versa. Any help would be much appreciated.

Thanks
Harry

**royUK** · 05-09-2008, 07:50 AM

Try

Please Login or Register  to view this content.

**sweep** · 05-09-2008, 07:54 AM

Or try this if you want the button to select on the other sheet, the cell you have selected on the first sheet

Please Login or Register  to view this content.

**baz0912** · 05-09-2008, 11:21 AM

Thanks very much for your help - Works a treat!

VBA - button to move to another sheet to same cell

LinkBack

Thread Tools

Rate This Thread

Display

VBA - button to move to another sheet to same cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions