| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro does not sheet name
"Todd" wrote:
Hi, Range("C7").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "'12010'!A61", TextToDisplay:="January" Never worked with hyperlinks, but I think what you want to do is change SubAddress to: SubAddress:= "'' & activesheet.name & "'A61" not 100% sure of the syntax, but if VBA acts like the INDIRECT function, this should work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro does not sheet name
Actually, it should be this:
SubAddress:=ActiveSheet.Name & "!A61" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro does not sheet name
Thank you! The second way is working.
"Marcotte A" wrote: Actually, it should be this: SubAddress:=ActiveSheet.Name & "!A61" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
| How to move rows from one sheet to another sheet (macro) | Excel Discussion (Misc queries) | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Linear Mode
