Selecting Dynamic Range

  • Thread starter Todd Huttenstine
  • 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
 
T

Todd Huttenstine

Sorry wrong newsgroup... Thought I was in
Excel.programming. Also ignore my other post. It was
meant for Excel.Programming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Range Selection 4
Need Help with a VBA subroutine 0
Look up by the Icon Set Color 0
how to format cells -fill color 2
Automatically change the text format the cell when use a specific text 10
Autofill Dynamic Range of Cells 2
#N/A displayed when Lookup Formula is copied 0
Saving a range for later reference 0

Top