How to drag a formula in the entire column in excel

Hello,

The shortcut to “Filldown” is Ctrl+D, so if you can select the range you want the formula to drag down to, then just use TypeInto.

For example,
Write Cell “formula”
Select Range
TypeInto “[d(ctrl)]d[u(ctrl)]”

‘d’ for down and ‘u’ for up to simulate the hotkey. (You might be able to use Send Hotkey too.

Selecting the range will require that you know the number of rows in your table. You can use dtVar.Rows.Count to find that number, then use it inside the Range field, like
“A2:A”+(dtVar.Rows.Count+1).ToString

Hope that gets you in the right direction.

6 Likes