Thread: Fill in formula with dymanic address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lok Tak Cheong Lok Tak Cheong is offline
external usenet poster
  
Posts: 14
Default Fill in formula with dymanic address
In worksheet1, I want to add formula such as
=SUMIF(worksheet2!$E$2:AA$241,$A2,worksheets2!AA$2 :AA$241)

However, the range (the last row) is changed accordingl to the import file.

I attempt to use VBA to fill in the formula.


Reply With QuoteReply With Quote