Search:

Type: Posts; User: funkykizzy

Search: Search took 0.01 seconds.

  1. Re: [Excel] Worksheet Variable in Cell Function Formulas?

    Thanks everyone! I got a solution:

    Sheets("Table").Cells(i, 3).Formula = "=MEDIAN('" & Worksheets(iSheet).Name & "'!G:G)"
  2. [RESOLVED] [Excel] Worksheet Variable in Cell Function Formulas?

    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...
  3. Re: [Excel] Workbook Function Error with Variables

    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...
  4. Re: [Excel] Workbook Function Error with Variables

    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...
  5. [RESOLVED] [Excel] Workbook Function Error with Variables

    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...
Results 1 to 5 of 5



Click Here to Expand Forum to Full Width