View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Murphy[_3_] Brian Murphy[_3_] is offline
external usenet poster
 
Posts: 2
Default Autofilling a formula to a variable last cell

Can someone please help me with the code for the following situation:

I have an excel worksheet that can vary in size by BOTH rows and
columns. I need to code an autofill of a formula from cell Q2 (the
starting point is always Q2) to the last cell. The Cells that I am
autofilling into are empty but the range is framed by Row 1 and Column
A which contain data out to the farthest point of that range in each.

Thanks,
Brian Murphy