Logo 
Search:

VB.Net Forum

Ask Question   UnAnswered
Home » Forum » VB.Net       RSS Feeds

VBA Excel Coding for dynamically changing function range

  Asked By: Syed    Date: Jul 25    Category: VB.Net    Views: 1809
  

I would like to dynamically changing the following Function range in VBA coding

"=SUMIF('ISA Master Sheet'!$K$7:$K$198,A8,'ISA Master Sheet'!$AO$7:$AO$198)"

In Function $K$198 and $AO$198 will be changed while the source('ISA Master Sheet') will have more rows. Right now source has 198 rows. If it grows how can I use the function through VBA coding ?

Can anyone please help ?
Thanks in advance.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on VBA Excel Coding for dynamically changing function range Or get search suggestion and latest updates.




Tagged: