1st cell of a row
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 ? |
1st cell of a row
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 ? |
1st cell of a row
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 ? |
1st cell of a row
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 ? |
All times are GMT +1. The time now is 03:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com