Macro to select & autofill adjacent cells

T

Tim Soddy

I would like to create/use a macro that selects a cell to the right of
highlighted cell and the two directly below. I then want to autofil
down this selection. I've tried to record a macro for this, but i
always performs the task at the same range - but I want it to wor
wherever I choose to highlight a cell from. Does anyone know how thi
can be accomplished?

Sincerely,
Ti
 
A

AlfD

Hi!

Yes: lots of people will know how;)

Why not post your macro: someone will show you how it can be tuned t
do more than just fill the three cells you recorded it filling.

Al
 
G

Gord Dibben

Tim

Sub tester()
ActiveCell.Offset(0, 1).Resize(3, 1).FillDown
End Sub

Gord Dibben Excel MVP
 
Top