Range using Variables

**subtilty** · 12-01-2011, 07:45 AM

Hi all,

I wondering how you would make this work.

I want:

Take the Date that is input into 'datefrom2' and search on the year to find it
Then when found move 3 columns across
Then input the character "H" into the cell
Then search for the Date that is input into 'dateto2' , move across 3 columns and input the character "h"
I then want all the cells between 'datefrom2' and 'dateto2' to fill with the charactor "H" aswell.

I really hope that makes sense. I started writing one below but I am not great at VBA.

Please Login or Register  to view this content.

**arlu1201** · 12-01-2011, 07:53 AM

It will be good if you attach the sample workbook you are using this code on. We can work through it and assist you better.

**subtilty** · 12-01-2011, 08:54 AM

Apologises, I have attached an example and noted it.

**subtilty** · 12-01-2011, 10:38 AM

Any one?

**arlu1201** · 12-01-2011, 01:18 PM

Use this code -

Please Login or Register  to view this content.

**Steffen Thomsen** · 12-01-2011, 01:30 PM

This can be done with slighly less code and a bit faster with this

Please Login or Register  to view this content.

**subtilty** · 12-02-2011, 05:22 AM

Thanks very much

Re: Range using Variables