Hello Folks, I need a vba code that can help me drag down a formula across filtered cells without a reference to the hidden cells. For example. With cells filtered as follows: A4 B4 A7 B7 A15 B15 A20 B20 The formular will be as follows: A7 = B4 A15 = B7 When I drag the formula down, it still picks up the hidden cells E.g A20 = B16

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Dragging formula across filtered cells

Thread starter stevenjoku61
Start date Sep 11, 2018
Tags

a20 cells filtered formula hidden

stevenjoku61

New Member

Sep 11, 2018

Hello Folks,

[FONT=&quot]I need a vba code that can help me drag down a formula across filtered cells without a reference to the hidden cells.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]For example.

[/FONT]
[FONT=&quot]With cells filtered as follows:[/FONT]
[FONT=&quot]A4 B4[/FONT]
[FONT=&quot]A7 B7[/FONT]
[FONT=&quot]A15 B15[/FONT]
[FONT=&quot]A20 B20[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]The formular will be as follows:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]A7 = B4[/FONT]
[FONT=&quot]A15 = B7[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]When I drag the formula down, it still picks up the hidden cells E.g A20 = B16[/FONT]