Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem concerning working with an uncertain # of rows
Use this
x = Activesheet.Usedrange.rows.count This will give u a count of all rows with data Then you can use a for loo for y = 2 to x cells(x,3)= MyValue 'start at row 2, column 3(C nex ----- Jim Lee wrote: ---- Hi all Based off a parameter query from a database, say I return the data t an excel worksheet with columns 1 & 2 below. Because the output i based off criteria, I don't know how many row entries there are fo the first two columns, and I need to make column 3. I'm going to t need to do this multiple times for multiple queries, so I want to mak a VBA function to make entries in col 3 and stop at the last row. An suggestions (Col 1) (Col 2) (Col 3 (row 1) 45 39 =(r1c1 + r1c2 (row 2) 34 78 =(r1c1 + r2c2 . . . . . . . . . ? ? ? Thanks much in advance Ji |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro to insert uncertain numbers of column with different value | Excel Discussion (Misc queries) | |||
Problem with functions working | New Users to Excel | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |