1.endxlup.offset1

  1. B

    Help with VBA ....Please

    Hi guys, I was hoping you can help. I have the below VBA macro running in a master file (named ZMasterFile). The idea is I have this file in a folder where up to 100 excel workbooks are stored and I use it to extract some data from each of the workbooks and collate on the ZMasterFile. It is...
    • braidp
    • Thread
    • 1.endxlup.offset1 erow filepath myfile sheet1.cellsrows.count
    • Replies: 3
    • Forum: Excel Questions
  2. W

    Excel to Word Formating + Customisable Table copy and paste

    Background information: I work with lots of products that require contracts where the contracts are largely similar but may have different fields have and different language required. I'm trying to automate this entire process where I have a main "Inputs" Page and based on what I check and fill...
  3. sharky12345

    Error trying to loop through cells and copy to another sheet

    I'm trying to loop through the non-blank cells in column A of a worksheet and then copy each of those values to another worksheet by using this; 'Import items Set ws = DestFile.Sheets("HandoverSummary") With DestFile.Sheets("HandoverItems") Lastrow = Range("A65536").End(xlUp).Row For Each cell...
  4. M

    Help with offset coding

    Hello All, I'm trying to do a simple module to save the results of a calculator (in excel of course) in a list. The code I am using is Sub SaveResult() Dim lRow As Long Dim ws As Worksheet Set ws = Worksheets("Calculator") lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1...

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