I want the data that is in the 1st cell of a row to be a variable, to use in
a message box. Ok if the user has selected say, A17

Dim Lname, Msg, Style, Title, Help, Ctxt, Response, MyString
Lname = Selection

Msg = "Do you want to delete" + Lname + " ?" ' Define message.

But if he's selected the whole row or say A17 to E17, this doesnt work.

I can t seem to get info() or row() to work ?

thanks if you can help ?

does this help

Sub msgboxdel()
MsgBox "Do you want to delete " & ActiveCell.Address
End Sub

--
Don Guillett
SalesAid Software

"Archie" wrote in message
...
I want the data that is in the 1st cell of a row to be a variable, to use
in
a message box. Ok if the user has selected say, A17

Dim Lname, Msg, Style, Title, Help, Ctxt, Response, MyString
Lname = Selection

Msg = "Do you want to delete" + Lname + " ?" ' Define message.

But if he's selected the whole row or say A17 to E17, this doesnt work.

I can t seem to get info() or row() to work ?

thanks if you can help ?

How about

Cells(Activecell.Row,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Archie" wrote in message
...
I want the data that is in the 1st cell of a row to be a variable, to use
in
a message box. Ok if the user has selected say, A17

Dim Lname, Msg, Style, Title, Help, Ctxt, Response, MyString
Lname = Selection

Msg = "Do you want to delete" + Lname + " ?" ' Define message.

But if he's selected the whole row or say A17 to E17, this doesnt work.

I can t seem to get info() or row() to work ?

thanks if you can help ?

Brill, you guys are stars !

"Bob Phillips" wrote:

How about

Cells(Activecell.Row,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Archie" wrote in message
...
I want the data that is in the 1st cell of a row to be a variable, to use
in
a message box. Ok if the user has selected say, A17

Dim Lname, Msg, Style, Title, Help, Ctxt, Response, MyString
Lname = Selection

Msg = "Do you want to delete" + Lname + " ?" ' Define message.

But if he's selected the whole row or say A17 to E17, this doesnt work.

I can t seem to get info() or row() to work ?

thanks if you can help ?