this really cant be that hard, however i'm having one of those days..
Part of my code is as follows;
There is a row of dates 15 cols wide, the start of which is in col 28. If there is a date already in this cell I just need to select the cell next to it (however my attempt at selection.end(xltoright).select hasnt worked because there are columns after this block of 15 with other data in it). If the cell is blank, i just need to select it.
Surely this is easier than I think it is..!!
Part of my code is as follows;
Code:
Cells(found.Row, 28).Select
'code not working correctly!!
If ActiveCell.Value <> "" Then
Selection.End(xlToRight).Select
End If
MsgBox ActiveCell.Address
There is a row of dates 15 cols wide, the start of which is in col 28. If there is a date already in this cell I just need to select the cell next to it (however my attempt at selection.end(xltoright).select hasnt worked because there are columns after this block of 15 with other data in it). If the cell is blank, i just need to select it.
Surely this is easier than I think it is..!!