ignore cell

  1. S

    For Loop to Change Cell Colors and Ignore Cells Based on Color?

    Hi everyone, hoping for your expertise. I am working with a set of data and trying to create a macro that, based on the cells that are selected, will return the highest value with the first button click, the second highest value with the second button click, etc. I have put together the below...
  2. dynamimic

    vba - how to ignore current cell before proceeding through Loop

    Hi there, vba virgin up until last week, but I'm trying to teach myself, so please go easy on me. I'm trying to create an Excel loop which will color rows blue meeting a certain criteria. My subroutine works, however, it always first colors the currently active cell blue before running through...
  3. S

    Concatenate a range but ignore any cell with 0.

    Hi there, I'm concatenating (is that a word?!) a range of data into one cell using the =CONCATENATE function. However, I want the function to ignore and skip any cell which has a '0' in. for example, data: A1= 7 A2= 0 A3= 9 A5 =CONCATENATE(A1,A2,A3) I want to see A5= 79, but have A5= 709

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