how to make this vba code active row not cell

[sspreyer]

how can make this active row not active cell
thanks in advance

Please Login or Register  to view this content.

[shg]

Could you provide a little context?

[sspreyer]

hi

basically im trying to a stop command button from working e.g if a13 to a500 has 133 enter in cell,the problem i have got is that if the cell is not first cell selected ie the active one the command button will work if i was to select cell from m13 to a13 the command button would work this why i think active row would work better but can seem to get it to work hope this helps. The macro is mail selection email button
many thanks again
shane

Please Login or Register  to view this content.

[sspreyer]

Could you provide a little context?

hi

basically im trying to a stop command button from working e.g if a13 to a500 has 133 enter in cell,the problem i have got is that if the cell is not first cell selected ie the active one the command button will work if i was to select cell from m13 to a13 the command button would work this why i think active row would work better but can seem to get it to work hope this helps. The macro is mail selection email button
many thanks again
shane

Please Login or Register  to view this content.