| Home |
| Search |
| Today's Posts |
|
#19
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula
Sorry it is opening sheet number below
"santaviga" wrote: Hi, sorry for not seeing your previous post, found it now and trying, it works to an extent, when I click on a cell say A1 it opens Sheet 2 and not sheet 1 as supposed to and son on, it always opens the sheet number above. Any ideas? Thanks "Lars-Ã…ke Aspelin" wrote: See my answer in another branch of this thread. Lars-Ã…ke On Tue, 6 Jan 2009 07:00:12 -0800, santaviga wrote: Is thre a way to have multiple cells and sheets working like I have cells A1:A50 with products in them and I need each of these cells when clicked on to relate to a sheet number 1 through 50, so if I click on cell A46 this will take me to Sheet 46 and so on, just wondering what the code would be for this. Regards "Lars-Ã…ke Aspelin" wrote: On Mon, 5 Jan 2009 14:08:03 -0800, santaviga wrote: Hi, I am looking for a formula or macro so that when an active cell is selected lets say cell A3 is selected excel will automatically go to a sheet number specified say Sheet 3. Any help would be much appreciated. Regards Try this macro in the worksheet where your cell A3 is located Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A3")) Is Nothing Then Worksheets("Sheet3").Activate End Sub Hope this helps / Lars-Ã…ke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use macro to copy formula with value and not formula without value | Excel Programming | |||
| Formula to use in Macro | Excel Programming | |||
| Is there a Formula or Macro for This? | Excel Discussion (Misc queries) | |||
| Formula in macro causes macro to fail | Excel Programming | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Threaded Mode
