LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Selec same row different column?

I've been trying to make a minor edit to a simple XLM macro which I
wrote many years ago. On running the macro from any cell it should
select the cell in col B of the same row.

FWIW, this shows the worksheet MACROGEN-3.XLM after unhiding it.

https://dl.dropboxusercontent.com/u/...lSameRow-1.jpg

I thought I could now edit it from

GotoColA
=COLUMN(ACTIVE.CELL())
=SELECT("rc["&-(ColA-1)&"]")
=RETURN()

to this

GotoColB
=COLUMN(ACTIVE.CELL())
=SELECT("rc["&-(ColB-1)&"]")
=RETURN()

But, without going into detail, I failed on several counts. So I'll
abandon that; even though many of those old macros appear to work, it
seems pointless to attempt to maintain or edit them.

Could I therefore get some help on a modern VBA macro to do it please?
Which presumably I should insert in PERSONAL.XLS (or PERSONAL.XLSM if
I rename it as I intend.)

--------------------

I did look for a KB shortcut and also tried using the GoTo dialog, but
failed there too.

--
Terry, East Grinstead, UK
 
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
How do I create multi choice selec drop down list in Excel please JillyB Excel Discussion (Misc queries) 7 March 3rd 08 09:41 PM
Selec the column to add in a listbox Ana Paula Excel Programming 1 February 2nd 07 03:12 PM
Macro to capture cell value then use it for a relative range selec PZ Straube Excel Programming 8 June 13th 05 08:28 AM
A recorded Macro to hide certain selected columns hides non selec. Mlmotter Excel Programming 2 December 31st 04 02:56 PM
To have an entire row highlighted to some color if any cell in that row is selec Nick Excel Programming 1 January 19th 04 03:09 PM


All times are GMT +1. The time now is 09:50 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"