Autofill to the right for variable amount of columns

[sideshow1]

Hi all,

I am trying to right a code that will autofill to the right in a row from the selected cell till there is no more data. So I will have fixed rows 3 and 4 with data starting at E3 and E4 but the amount of columns is going to change.

I want to E5 to be E3*.05 and apply to all the number in row 3 until last column with data. So then F5 would be F3*.5. I apologize if this is confusing, I am very new to vba.

Any help is greatly appreciated.

[protonLeah]

Please Login or Register  to view this content.