How to write a Macro to drag row down and then Copy and Paste special values

[Blazernfire]

Hi,

I need to write a macro to drag a row down where the formula is in the range (A27:I27) and then go back to the row where the formula is and do a copy and paste special in about 10+ tabs that I have in one workbook. The range number varies from tab to tab. Can this be done?

Thanks.

 

[JackDanIce]

Welcome to the board. Code below will work for a single sheet. You can put this code into a loop to loop through several sheets:

Sub UpdateResults

Dim LR as Long

LR = Range("A" & Rows.Count).End(xlUP).Row - 27 + 1

With Range("A27").Resize(LR, 9)
    .FillDown
    .Calculate
    .Value = .Value
End With

End Sub

 

[Blazernfire]

Ok thanks. How do I put this in a loop?

 

[Blazernfire]

Hi,

the macro didn't really work. I want the formula to be dragged down only 1 row and then the row with the formula to copy paste special values.

Thanks.