end column with data

  1. Z

    Macro to set blank cells for to zero for several columns

    I need help modifying this code. I want to set any blank values in column A to zero. This macro works for this but I have to specify the range. I want the range to select all of the data in the column. ie. if the last cell was A563 I want the macro to be only applying this change from cells...
  2. K

    Macro to sort worksheet based on last data row and column

    Hi, I am working on a macro in which constantly gets updated with new columns each quarter and new rows each quarter. To avoid having to update the macro every few months to reflect the new rows and columns, I would like to edit the sort button to go to the end of the columns (all have headers)...
  3. M

    Macro to copy each rows last column used contents to another cell in the same row

    Currently this does the job for only the first row - I need it to loop through all rows: Sub LastCellBeforeBlankInRow() Range("A3:A6800").End(xlToRight).Copy _ Destination:=Worksheets("Sheet3").Range("AA1") End Sub
  4. C

    Variable Column Selections Macro

    Hello all I'm trying to write a Macro for the following: I have a list of suppliers in column A and each month a score is generated for that supplier and the data put in columns, i.e. B has january score, C has february score etc. I want the macro to arrange the suppliers in order of the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top