Skip to main content
Super User

Return to Answer

Improved Formatting
Source Link
phuclv
phuclv
  • 28.4k
  • 15
  • 128
  • 252

Press ALTAlt+F11F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells
 

Range("B1:B10000").FillDown

Range("B1:B10000").FillDown

Edit
Or. Or just add the formula with VBA
 

ActiveSheet.Range("B1:B10000").formula = "=A2+2"

ActiveSheet.Range("B1:B10000").formula = "=A2+2"

Press ALT+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells
 

Range("B1:B10000").FillDown

Edit
Or just add the formula with VBA
 

ActiveSheet.Range("B1:B10000").formula = "=A2+2"

Press Alt+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells

Range("B1:B10000").FillDown

Edit. Or just add the formula with VBA

ActiveSheet.Range("B1:B10000").formula = "=A2+2"
added 12 characters in body
Source Link
M.Johnson
M.Johnson
  • 11
  • 2

Press ALT+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells

Range("B1:B10000").FillDown

Edit
Or just add the formula with VBA

ActiveSheet.Range("B1:B10000").formula = "=A2+2"

Press ALT+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells

Range("B1:B10000").FillDown

Edit
Or just add the formula with VBA

Range("B1:B10000").formula = "=A2+2"

Press ALT+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells

Range("B1:B10000").FillDown

Edit
Or just add the formula with VBA

ActiveSheet.Range("B1:B10000").formula = "=A2+2"
Source Link
M.Johnson
M.Johnson
  • 11
  • 2

Press ALT+F11 to open the VBA screen. This code should copy down the formula, just change the Range to the correct cells

Range("B1:B10000").FillDown

Edit
Or just add the formula with VBA

Range("B1:B10000").formula = "=A2+2"