View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Lee Jim Lee is offline
external usenet poster
 
Posts: 1
Default Problem concerning working with an uncertain # of rows

Hi all,

Based off a parameter query from a database, say I return the data to
an excel worksheet with columns 1 & 2 below. Because the output is
based off criteria, I don't know how many row entries there are for
the first two columns, and I need to make column 3. I'm going to to
need to do this multiple times for multiple queries, so I want to make
a VBA function to make entries in col 3 and stop at the last row. Any
suggestions?


(Col 1) (Col 2) (Col 3)
(row 1) 45 39 =(r1c1 + r1c2)
(row 2) 34 78 =(r1c1 + r2c2)
. . . .
. . . .
. . . .
? ? ? ?

Thanks much in advance,
Jim