mention

  1. E

    converting excel formula to vba

    hello i am new to vba can any one help me converting this excel formula =INDEX($C$7:$C$2001,AGGREGATE(15,3,IF($C$7:$C$2001=$J$5,ROW($C$7:$C$2001)-ROW($C$7)+1),ROW(A1))) to vba code please do mention where to type value that needs to be searched and where will i get the answer this formula...
  2. L

    Runtime Error 1004 copy method of Worksheet class failed

    Hey everyone! I have a workbook that keeps throwing the title error when attempting to copy a worksheet from one workbook to another. This error is so common that, in order to make sure I got it right in the thread title, I used Google's autocomplete. But whenever I look it up, the...
  3. V

    Pivot Row need to be dynamic..

    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "export!R1C1:R13002C10", Hi Everyone, can anyone pls help me on this.. Columns are fix from A to J. Rows will go change. how do I mention here dynamic range..?
  4. V

    Do Until Loop logic help

    Do Until lx = 12 Loop 12 is Col L. how do i mention lx is the column to increment..??
  5. D

    Microsoft outlook object library missing

    Hi, I believe I am using office 16, when looking up the above library in the reference library, I can find no mention of outlook at all. Is it called something different?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top