Drag VBA Formula

[ashahrul11]

Hi guys, I would like to ask, how can i drag VBA Formula?

Okey this is my formula for my excel project...

Private Sub CommandButton3_Click()
Range("G5").Value = Range("G5").Value - Range("K5").Value
Range("K5").Value = ""
Range("G5").Value = Range("G5").Value + Range("I5").Value
Range("I5").Value = ""

Whenever i press the button, it will update my stock level.

Thanks if you can help me.

 

[Joe4]

Welcome to the Board!

Not sure what you mean... Can you explain in more detail?
Are you asking how do you get the macro to be applied to the next row, or how to apply it to a bunch of cells at once?
Can you explain exactly how it can be determined which rows it should be applied to when run?

 

[Special-K99]

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html