lastcolumn

  1. M

    Challenging: VBA to Combine (1) Naming Ranges with Another Range's Values; (2) Row & Column Loops; (Finding Last Row/Column)

    I have a lot of ranges I need to name. I want to use VBA to name every range in a column by referencing another column that contains the range names to be used. For instance, I want to name cell E3 (which has a value of 1) with the name in cell A3 (JillJan). Then, name cell E4 (which has a...
  2. Y

    VBA: copy import file data below current data

    Hi guys, I am relatively new to VBA, and I am getting stuck with my code. What I want to achieve is to import a file on a daily basis and copy that data in another worksheet below the existing data. I keep getting the following error: "Runtime error: 1004. We can't copy because the Copy and...
  3. A

    autofill macro for column

    HI, i want to autofill my formula to the last column. here is my code Dim LastColumn As Long LastColumn = Cells(5, Columns.Count).End(xlToLeft).Column Selection.AutoFill Destination:=Range("B1:" & LastColumn & "1"), Type:=xlFillDefault I have suceed count the last column by variable...
  4. C

    Running a looping macro on another sheet within the same macro help "For control variable in use"

    I am running quite a complex code at the moment to analyze employee id's in a set of teams. The road block I am facing is that my code has to run an autofilter for an unknown amount of unique filters, copy the column A on Sheet 1, and then paste into my data (2) sheet in Column A. From there I...
  5. D

    VBA - Master Copy File not all columns will copy

    I'm trying to create a macro that will take a daily pre-designed format sheet (people just input the numbers in to rows, and columns) and insert them into a combined yearly master. It will copy all the rows just fine it seems at the moment, but it stops at column CD and I need it to go to CQ...
  6. N

    Last Row Average VBA

    How can I put an average of the last row in the first empty column of the same row? Here is what I tried: <tbody> Sub LastRowAve() lastrow = ThisWorkbook.Sheets("sheet1").Cells(Rows.Count, 1).End(xlUp).Row lColumn = ThisWorkbook.Sheets("sheet1").Cells(1, Columns.Count).End(xlToLeft).Column...
  7. R

    VBA to get last row and column, then copy and paste

    Hello, As
  8. R

    Variable range

    Hi there, I've got a short question: I have two variable ranges: One in row 4, starting in column F One in Column E, starting in row 5 I want to set a range for a macro for these two variable ranges. So one is Range("F4:.....") and the other one is Range("E5,....). I have to find the Last...
  9. A

    Find Last Column

    Hello and thank you for taking the time to review my question., I am trying to calculate the numerical value of the last Column with data in a work sheet from Cell A3 so that I can do some fun stuff to the right of it. I do not need to know the column locations such as A, B, AA, but rather, I...

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