HOpefully quick question.

I have code that looks to see if a block of cells meets my criteria.
If it does, then I need to perform some operations on that block.
Everything is in 1 column (Col A) if that helps.

What my code does it to first identify a block of rows in Column
where 6 consecutive rows are non-blank. I need to copy the bottom fiv
rows of this block and transpose them in column B, on the same row tha
starts the block.

When I hard code cell references, it works fine. My problem is that
can not hard code cell references for the entire procedure, becuaus
rows will be deleted. My long winded question is as follows:

How can I set the Range(Cells(8,1),Cells(12,1).select to be define
dynamically relative to the active cell (the first cell of the block)?

Thanks in advance,

Broc

--
Btiber
-----------------------------------------------------------------------
Btibert's Profile: http://www.excelforum.com/member.php...nfo&userid=855
View this thread: http://www.excelforum.com/showthread.php?threadid=52975