rownumber

  1. E

    Loop through sheets in another workbook

    Hi all, Need some help adding some coding to loop through tabs in another workbook. The code opens up a file(s) in a specific folder and the aim is to just copy all data in all tabs into one tab within DataDump file. Sub Execute_Files()Dim objFSO As Object, objFolder As Object, objFile As...
  2. O

    Compile Error Next With For

    Thanks in advance for any suggestions and I will give feedback on them. I get the following error "Compile error: Next without for on Next i Sub ClearCFData() 'Dimensioning Dim i As Integer Dim RowNumber As Long 'Turn Off Screen Updating...
  3. A

    was ok - suddenly get error 91

    Dim RowNumber as long RowNumber= Columns("B").find(what:=cboJump,,xlValues,, xlRows,,,False).Row The code is in Worksheet cboJump_KeyDown event. I'm sure this worked yesterday I also tried Dim Rownumber as Range and "Set RowNumber = ..." but same error.
  4. I

    reference to cells with variable rownumbers to be found in another cell

    I want to use the formula MAX(C3:C8) (or any other formula in fact), but instead of the indices 3 and 8 I would like to indicate two numbers that are to be fetched from a certain cell (or 2 cells of course). For example : cell A23 contains 5 and cell A24 contains 12, and I would like to see the...

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
Back
Top