Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function in VB
I have two sheets in the first sheet in the column A
contains accounts name and in the column B figures. The second sheet contain the same thinks but is updated from the first sheet. The sumIf Function in VB as I mentioned below is working just for one cell. My question is if it is possible to apply the same function to the rest cell but of course the result will be different and spread to the remainder cells. -----Original Message----- A few more details would help. Surely you don't want every cell to have this result? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Costas" wrote in message ... I use a worksheet function in VB and specificly the sum if. This is working properly but only for one cell what is the easy way to do for a lot of cells. Set Myrange = Sheet2.Range("a10:a100") Sheet1.Range("f10") = _ Application.WorksheetFunction.SumIf((Myrange) _ , Sheet1.Range("b10"), Sheet2.Range("C10:C100")) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet function in VB
I offered a possible solution/interpretation of your question in your
original thread. Please stay in the same thread. -- Regards, Tom Ogilvy "costas" wrote in message ... I have two sheets in the first sheet in the column A contains accounts name and in the column B figures. The second sheet contain the same thinks but is updated from the first sheet. The sumIf Function in VB as I mentioned below is working just for one cell. My question is if it is possible to apply the same function to the rest cell but of course the result will be different and spread to the remainder cells. -----Original Message----- A few more details would help. Surely you don't want every cell to have this result? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Costas" wrote in message ... I use a worksheet function in VB and specificly the sum if. This is working properly but only for one cell what is the easy way to do for a lot of cells. Set Myrange = Sheet2.Range("a10:a100") Sheet1.Range("f10") = _ Application.WorksheetFunction.SumIf((Myrange) _ , Sheet1.Range("b10"), Sheet2.Range("C10:C100")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with worksheet function | Excel Discussion (Misc queries) | |||
VBA worksheet function | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
IF Worksheet Function | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions |