Search:
Type: Posts; User: funkykizzy
Search:
Search took 0.01 seconds.
-
Thanks everyone! I got a solution:
Sheets("Table").Cells(i, 3).Formula = "=MEDIAN('" & Worksheets(iSheet).Name & "'!G:G)"
-
Hi again!
Is it possible to use a variable worksheet reference in the string of a cell formula? For example, I want to loop through sheets 2-13 (out of 15) and calculate the median for all...
-
I think I might have resolved the error, I was writing my code in a worksheet instead of a workbook module. That seems to perform the actions I am looking for without error. The next step will be...
-
Thanks Westconn1!
I was afraid of that...I heard that this might happen but I was hoping that it would be something else.
The only other way I can think of accomplishing my task is to write out...
-
Hi Everyone! :wave:
I am trying to create a final table of statistical data from a large database export. I have been successful at parsing the data into a new workbook by sheets, now I just need...
|
Click Here to Expand Forum to Full Width
|