Posted to microsoft.public.excel.misc

SteW

external usenet poster

Posts: 293

Hyperlink Question

Hi all

In the following formula I would like ideally for the C
reference,HYPERLINK("#'date details'!C"&(( to change to D and E and F as I
drag the formula accross the columns. As the C is in the Inverted Commas it
does not change. Any Suggestions
=HYPERLINK("#'date details'!C"&((COLUMN()+34)),'Date Details'!C36)

Thanks for looking

Stew

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink Question	Micky	Excel Discussion (Misc queries)	1	August 20th 08 09:25 AM
Hyperlink Question	nastech	Excel Discussion (Misc queries)	0	November 1st 05 11:41 PM
Hyperlink Question	Phil Osman	Excel Discussion (Misc queries)	4	March 29th 05 03:11 AM
Hyperlink question	Greg B	Excel Worksheet Functions	1	March 8th 05 04:42 PM
hyperlink question	Arul	Excel Worksheet Functions	2	December 3rd 04 11:46 PM

All times are GMT +1. The time now is 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us