Auto fill formula in an entire excel column

Help
,
1

Hi,
I am trying to send a hotkey to auto fill the formula by selecting a range in an excel, but this isn’t working
PFB SS for better understanding
In the SS:
I have written a formula in W6 cell, selected a range but when I am sending a hotkey the formula isn’t applying for the entire column.

image

Thanks

2

Hi @PDcoder

  • We have an activity to auto fill the formula Auto fill range
  • You can enter the formula Using Write Range.
  • In **Auto fill Range we just have to provide Source Range Which contains our Formula nad destination Range Which where we have to fill the Formula.
    Thanks & Regards
3

Hi Jitendra_123
We followed the steps you provided,but getting attached error.
ErrorSS

4

Hi @marirajamca1
Make sure in the destination range you are providing range from source cell to destination cell. If your formula is in A2 Cell Then Your Source Range will be “A2” and if you want to fill this formula up to A10 Cell then your destination range will be “A2:A10”. I hope this will help you.
Thanks & Regards

2 Likes
5

Hey, I have same issue to struggle with. Can you help me with sample flow ? I am confused how Can I find the range without header count. I am getting the range +1 by “F:F”+(read.Rows.Count+1).ToString . Also How Can I write formula ?