Macros for Autofill( click & drag)- Acticv cell to last row by its side

Hello Friends,

I just joined today and need some help...

I am writing a macros for a challenging excel format....
My solution is based on cell movements
however i am facing a road block when i try and click and drag from the active cell that i have landed on to the last column beside it

Selection.Offset(0, 3).Select
click and drag till last cell beside it may vary

e.g

A B
8/9/2012 Active cell where i am.... may not necessarily be B1 could be any permutation the same goes for column A
7/31/2012
7/28/2012
8/7/2012
8/8/2012



Thanks,

Prithviraj

Hi Was,

Thanks for your speedy response...
i did try ur code howver it fills 'All' the cells beside it
what i am really trying to do is use it like a simple click and drag where the tool would understand where to stop basis the data on its left

for.e.g if all cells are pouplated from a1 to a65 then the code drags b1 till b65
please note that my cell position would change basis the data...Thanks

yes ...slight difference there could be a blank cell and then data again in Row A
the code should only read till the last row till the break...thats A11 in this e.g.

A B
1 1 z
2 1 z
3 1 z
4 1 z
5 1 z
6 1 z
7 1 z
8 1 z
9 1 z
10 1 z
11 1 z


14
15
16

Thanks again

Thanks mate... appreciate all ur help and time...
The Was code is good for users who may try it nxt.....

Have a good one... Cheers...