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?

Some videos you may like

This Week's Hot Topics