Excel 2003 - How to set variable using selected row and a column? 1

[DBLoser]

I'm trying to define a variable based on the value of a cell. The column is static but the row is ActiveCell.Row. I can't find how to reference it.

Something like: MyVariable = (B,ActiveCell.Row)

...where B is the column and ActiveCell.Row is the row I need. The example above doesn't work but it's what I'm trying to accomplish.

Many Thanks!

 

[SkipVought]

hi,

You supply the column number...

MyVariable = cells(ActiveCell.Row, YourColumnNumber).value

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DBLoser]

I get Run-time error '1004':

Application-defined or object-defined error

Here's the code:

Public MyVariable As String
Sub ApplyHyperlink()

MyVariable = Cells(ActiveCell.Row, BQ).Value

Sheets("Master").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=MyVariable

End Sub

In the code window when I mouseover the ActiveCell.Row variable, it does contain the the row number but BQ = empty. I am sure there is a UNC path & filename in that cell.

 

[DBLoser]

I get Run-time error '1004':

Application-defined or object-defined error

Here's the code:

Public MyVariable As String
Sub ApplyHyperlink()

    MyVariable = Cells(ActiveCell.Row, BQ).Value
    
    Sheets("Master").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=MyVariable
    
End Sub

In the code window when I mouseover the ActiveCell.Row variable, it does contain the the row number but BQ = empty. I am sure there is a UNC path & filename in that cell.

 

[SkipVought]

what value in BQ? EMPTY, cuz you wanted Column BQ, yes?

Public MyVariable As String
Sub ApplyHyperlink()

    MyVariable = Cells(ActiveCell.Row, "BQ").Value[b]

'Your VARIABLE has NO ADDRESS!!!    [/b]
    
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DBLoser]

That was it. Thank you very much!

Have a star.