The best and most plausible way to do this is to use a userform; it has been designed for this purpose (control the user's input).
The best and most plausible way to do this is to use a userform; it has been designed for this purpose (control the user's input).
it is glitching sorry
If Not IsEmpty(Worksheets(SheetContainingtheCells).Range( "G" & lngRows)) Then
says that is a subscript out of range and highlights the above line
Bookmarks