find last record row

  1. D

    Changing Value of a Cell Excel VBA Macro

    Hello, I am working on a code that writes labels to each row on a worksheet. The worksheet is comprised of a header row, which has a header for each category: |ID|Category|Sub-Category|Metric|Sub-Metric|Unit|Priority|Existing Reference|Comments|Data Link| Last row of the sheet can very...
  2. K

    excel 2003 vba setting last row in userform initialise

    I am having trouble with my PREV & NEXT command buttons on userform where it thinks the last row used is row 3. Row 3 is the starting row with data but is not the last row with dat. I suspect the problem lies within my Userform_initailize procedure but I cannot figure out the answer after very...
  3. C

    Macro that can Ctrl-D a formula

    Hi all.. I am making a macro that preps a spreadsheet for upload into a database application. What I need to know is this: the last step of the macro has a formula in the first cell of an empty column. I have it set now so the user has to Ctrl-D the formula to the last row of records, then...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top