Selecting Dynamic Range

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Good afternoon!

I need to print a specific range of data but first I need
to know the cells that comprise the range. I know the
range will always start with cell D7 and will only go
through ColumnE. So now all I need is to know how far
down in rows to select. In order to do this I need for
Excel to look in ColumnD and see what the last cell is
that contains the background color light green. For
instance lets say the last cell in ColumnD that contains
the background color light green is cell D75. If this is
the case I need for it to select the range D7:E75.

What is the code that will do this?


Thank you
Todd Huttenstine
 
Sorry wrong newsgroup... Thought I was in
Excel.programming. Also ignore my other post. It was
meant for Excel.Programming
 
Back
Top