For Each c In Range(Cells(4, ActiveCell.Column), _
Cells(56,ActiveCell.Column))

would become

For Each c In Range(AcitiveCell, Cells(56, _
ActiveCell.Column))

--
Regards,
Tom Ogilvy

"alymcmorland"
wrote in message
news:alymcmorland.1x3v2i_1129651567.1657@excelforu m-nospam.com...

Coll, that works well good, but is there a way instead of it always
being cell 4 to cell 56 that gets changed is there a way to declare the
first cell as the active cell and then do it from there until cell 56?

So if i was on E25 and i ran the macro i'd want all the cells below
E25, so up to E56 to change but i'd have to declare that cell E25 was
the start cell.

Is this possible? and if so how would i go about altering the code to
incorporate it?


--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile:
http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=477143