last cell used

  1. JZonneveld


    Hi, I am new to VBA and these forums but since every question I put in Google directed me here I figured I'd just make my own account. I can't find a way to use the END, SHIFT+ENTER function from VBA. This is important because the file contains empty cells and the amount of colums varies per...
  2. J

    how to fill formula till lastrow?

    Dim sht As Worksheet Set sht = Sheets("REX") LastRow = sht.Range("A75").Rows.Count Range("F75").Value = "543" Selection.AutoFill Destination:=Range("F75:F" & LastRow) I am trying to put value starting F75 to last row of F, but It's not working. Is there any way to fix this code to work?
  3. O

    Find Last Cell in column (Ignore formulas)

    Hy All, I'm having trouble finding a way to find the last cell in column ignoring formulas. Honestly I found some pieces of code in a already existing thread in this forum. I tried this one I found, but returns error Dim oneArea As Range, finalCell As RangeSet finalCell =...
  4. S

    Set print area for multiple sheets using VBA

    Hello, I am very new to VBA and I am looking to create a macro to define the print area for each worksheet in my workbook. Currently this is the code I am using and it is assigned to a button; the trouble I have is that instead of setting the print area to the last cell of each worksheet (the...
  5. L

    Find last column with value?

    Hi all I am looking fo a way to find the last entry accross in a large data set, excluding heading etc. data is all numbers within the range AU100:YT10000. I already have a countA to validate a columns with data, returning (1 or 0), but I would like to have a row above that looks at the...
  6. B

    Macro to open Multiple Files in a Folder and Copy Key Elements out but will not find correct last available cell

    I am trying to take some data out of a couple hundred sheets. Basically I open each one by one pull the key data and find the last available cell in column D as the start point to paste to from the next file. It seems to keep selecting row 23 (even though the cells up to 2 are empty) and then...
  7. B

    Connecting a cell to the last cell of entered data, HELP!

    Hi everyone, So I'm creating a tracker for a project at work. I'm tracking communication with a group of companies (sales). Anyway, I'm using the first worksheet (i.e. the one on the far left) to keep a summary of the last communication I had with the company. Each subsequent worksheet...
  8. K

    Add Semicolon to Last Cell in Row

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  9. H

    Copy Paste Last Cell used VBA

    How do I copy data from different worksheet at the end of existing data in active spreadsheet using VBA?
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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
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 "".
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