Mulheres Nuas Lebiscas

method used cell SpecialCells (LastCell) in the range (1)






' Find the last cell used (LastCell) in I

Range Sub Excel_Macro_ultim_cell_antes_de_una_celdaEnblanco ()
'With this macro code can be selected by the last cell vba
' used in the column before a blank cell

'as shown in the image of Excel is selected
cell 'E5 cell is just before the first empty cell (E6)
' with this parameter (xlDown) seek the cell with downward direction

Range ("E1"). End (xlDown).


Select End Sub





Sub Excel_Macro_LastCellInColumn ()
'using this macro may select the last cell used
' E10 as shown in the image

Range ("E65536"). End (xlUp).

Select End Sub Sub


Excel_Macro_Ultiam_celda_antes_deBlanco ()
'using this macro you can search for
' the last cell used before a blank cell
'but this time with the right direction (xlToRight) of initial cell

Range ("A2"). End (xlToRight).

Select End Sub
Sub
UltimaCeldaUsada ()
'This macro can be used to find the last cell
' on the Road

ActiveSheet.Cells.SpecialCells (xlCellTypeLastCell).

Select End Sub