Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Goto

Hi

I have a makro there get the user to a cell
Nomally i have
Range = ("A1").select

But now i want to get the value from another Sheet / Cell
i have trye with
Range = Sheets(Celler!A1).Select

But i dosn't work

What i want is to have a value in Sheets(Celler!A1)
and then use this value in a macro
so the user goto the value there are in Sheets(Celler!A1)
Not to Sheets(Celler!A1) but to the value there are in Sheets(Celler!A1)

Hope some one understand and can help

regards
alvin

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
IF then GoTo [email protected] Excel Programming 3 November 25th 06 11:21 PM
If.....Then GoTo....... Alec H Excel Discussion (Misc queries) 4 February 22nd 06 02:42 PM
On Error Goto doesn't goto Paul Excel Programming 1 October 15th 04 03:51 PM
On Error Goto doesn't goto Paul Excel Programming 0 October 15th 04 03:05 PM
Goto next used row JonWayn Excel Programming 0 November 20th 03 03:00 AM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"