"button" to move curser to a specific cell based upon formula results in another cell

**Araise** · 01-15-2014, 07:17 PM

A1 has the function =Today() in it

The range (or row) D2:QU2 contains days for the next year

I would like to have a "button" in cell A2 that when pressed, will take the curser to today's date in the range specified.

Kind of like a hyper-link

**alansidman** · 01-15-2014, 09:27 PM

try this:

Please Login or Register  to view this content.

**martindwilson** · 01-15-2014, 09:52 PM

you could actually use a hyper link

=HYPERLINK("#"&ADDRESS(2,MATCH(A2,D2:QU2,0)+3),"jump to today")

**alansidman** · 01-15-2014, 09:59 PM

@Martin--very nice.

**Araise** · 01-16-2014, 03:16 PM

Thanks to all of you. I went with the hyperlink and it is exactly what I want. Thanks again, all

**alansidman** · 01-16-2014, 03:21 PM

Thanks for the rep.

"button" to move curser to a specific cell based upon formula results in another cell

LinkBack

Thread Tools

Rate This Thread

Display

"button" to move curser to a specific cell based upon formula results in another cell

Re: "button" to move curser to a specific cell based upon formula results in another cell

Re: "button" to move curser to a specific cell based upon formula results in another cell

Re: "button" to move curser to a specific cell based upon formula results in another cell

Re: "button" to move curser to a specific cell based upon formula results in another cell

Re: "button" to move curser to a specific cell based upon formula results in another cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

VBA Code- Move/Split cell content based on ","

Change "Parent" cell based on results of multiple "Children" cells

when i push the "end" button the curser always goes to cell S47

Formula in "Cell Link" box of Option Button?

Bookmarks

Bookmarks

Posting Permissions