last cell used

  1. JZonneveld

    END, SHIFT+ENTER in VBA

    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?
    • jaik22
    • Thread
    • last cell in range last cell used last cell/column
    • Replies: 3
    • Forum: Excel Questions
  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...
    • Snail123
    • Thread
    • last cell used multiple worksheets print areas vba & excel 2013
    • Replies: 5
    • Forum: Excel Questions
  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...
    • LORDMARKS
    • Thread
    • last cell last cell used last cell value last cell/column
    • Replies: 0
    • Forum: Excel Questions
  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

  • Problem in vba vlookup
    • Started by roykana
    • Replies: 37
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    • Started by Joseph111
    • Replies: 26
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    • Started by Goalexcel
    • Replies: 25
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    • Started by microhunt
    • Replies: 24
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    • Started by Marq
    • Replies: 23
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top