VBA change background color of cell with overflow

[Kra]

Hi all,

Is it possible to recognize overflow in macro?

I have a macro that changes background color of a selection. So basically I type some string in cell A1, but it is long enough to overflow till cell D1. I select range A1:D1 and then I run macro to format it the way I need. But selecting the range every time is a bit annoying and I wonder if it is possible for macro to recognize overflow. So I select only cell A1 where string is stored, but it formats A1:D1