Use the Selection object. E.g.:

Selection.Interior.ColorIndex = 6

In article , noyb
wrote:

I want to work with a range; the location, size etc., is defined by the
user highlighting an area on the worksheet then starting up a macro. How
do I use the currently highlighted area as a range?
Thanks