Thread
:
1st cell of a row
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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 ?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett