Code to see User Row Selection

[slimimi]

Hi there - using excel 2003.

Please can someone tell me the code i need to type so that excel will find a cell (based on current user row position) together with Column B???

Thanks in advance.

 

[Fazza]

Hi. Like this?

debug.print cells(activecell.row,"B").address

 

[Jon von der Heyden]

Maybe:

Range("B" & Selection.Row)

Regards
Jon

 

[Boller]

By "based on current user row position", I'll presume you mean the active cell row :-

Cells(ActiveCell.Row, 2).Select

(This is based on a different presumption than Jon von der Heyden's post)

 

[slimimi]

Thanks alot guys.
How do i implement that code and where to paste it?
Basically - code looks at range B or Column B & Selection Row and then looks for a file in, eg, Folder - Trade Logs - Subfolder - Chart Pics. Once it finds the file - it inserts it as a hyperlink into the same cell it looked in earlier, ie, Range B & Selection Row.

Really appreciate your kind help.

 

[slimimi]

Can i just add to that - if code does not find file - it opens a message box with 2 command button options to CANCEL (unload message box) and then places the text "No Chart" in the same cell it looked in earlier. and a TRY AGAIN button which will simply just run the macro again.

THANKS in advance...

 

[Boller]

What do you mean by "Selection Row" ?

Do you mean the active cell row, or the first row in the selection?

 

[slimimi]

Hi Boller - sorry and thanks for your help.

I mean the active cell row on, eg, Sheet1.

Example, user is logging in details on row 6.
All code should pertain to that row (6) in this case.

Does that make sense? Sorry if i haven't made myself clear.
Please tell me what other info you need.