Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Last row to an email address in the last active cell
How would i email the last row of a spreadsheet to whatever email address was
in the last cell of that last row, I have used Ron de Bruin's code to email the last row to a pre defined email address, but this address will change on a row by row basis and will be in a cell on that last row. Thanks very much in anticipation of any answers I may get. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Last row to an email address in the last active cell
You can use something like this
Sub LastColumnInOneRow() 'Find the last used column in a Row: row 1 in this example Dim LastCol As Integer With ActiveSheet LastCol = .Cells(1, .Columns.Count).End(xlToLeft).Column End With MsgBox LastCol End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Carl Irving" <Carl wrote in message ... How would i email the last row of a spreadsheet to whatever email address was in the last cell of that last row, I have used Ron de Bruin's code to email the last row to a pre defined email address, but this address will change on a row by row basis and will be in a cell on that last row. Thanks very much in anticipation of any answers I may get. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending to email different email address based on cell value | Excel Programming | |||
Send data from Excel in email from specific email address | Excel Programming | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) |