Filling a selected range automatically
 

Hi, I have a large data table 10,000+ items, that I want
to manually assign to groups. For instance 4 of the items
are grouped so i want to assign these for items a number.
The next 7 items are grouped so i want to assign them the
next incremental number. Incrementng a number is not a
problem, what i would be looking to do is highlight
several sequential cells then hit Ctrl + B or what ever
to trigger the macro and have the cells all filled with a
number, then highlight another set of cells, and run the
macro and fill these cells with the next incremented
number. This way several items can be grouped quickly...
any suggestions as to how i fill a previously selected
raneg with a value ?

Filling a selected range automatically
 

Intersect(Selection.EntireRow,Columns(3)).Value = 8 fills column C of
the selected rows.

or just Selection.Value = 8 if you want the selected cells to be filled.

--
Regards,
Tom Ogilvy


"Neil" wrote in message
...
Hi, I have a large data table 10,000+ items, that I want
to manually assign to groups. For instance 4 of the items
are grouped so i want to assign these for items a number.
The next 7 items are grouped so i want to assign them the
next incremental number. Incrementng a number is not a
problem, what i would be looking to do is highlight
several sequential cells then hit Ctrl + B or what ever
to trigger the macro and have the cells all filled with a
number, then highlight another set of cells, and run the
macro and fill these cells with the next incremented
number. This way several items can be grouped quickly...
any suggestions as to how i fill a previously selected
raneg with a value ?