PDA

View Full Version : Sleeping: Selecting Hidden Cells & Auto fill



bay_analyst
10-10-2004, 08:07 AM
I have two problems that I need your help with.

The first is I need to select cells that are in hidden columns. They will always be in row 6. What I need to do is select the first hidden column, row 6. It will keep changing as the weeks go on. The first week, the first hidden column is V, so I need V6 selected. The next week the first hidden column will now be W.

My second problem is there any way to Auto fill a formula down to the cell in the last row with data in it. The last row used will change constantly so I can't use cell references. I also can't use regions as there is some rows with no data in them.

Thanks in advance for all your help. This forum is the best, with such friendly, helpful and knowledgable members.

Darlene

Jacob Hilderbrand
10-10-2004, 01:31 PM
Why do you need to select the hidden cell? It may not be necessary to select. We cal probably use Cells() here. Let's say Col represents the Column then:

Cells(6, Col).Select
You can determine the last row like this:

LastRow = Range("A65536").End(xlUp).Row
Then to Auto Filter:

Range("A1:A2").AutoFill Destination:=Range("A1:A" & LastRow), Type:=xlFillDefault