Prev: disable macro/code after date & time
Next: Need help with Trim function
From: Carl Irving Carl on 20 Apr 2010 12:14
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.
From: Ron de Bruin on 20 Apr 2010 12:31
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 Irving(a)discussions.microsoft.com> wrote in message news:040EF1E9-CDAE-49A5-A32D-9C03026836BC(a)microsoft.com...
> 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.
 | 
Pages: 1
Prev: disable macro/code after date & time
Next: Need help with Trim function