do nothing

Dear All, I currently have a spreadsheet which is to be used by others to track their monthly and quarterly payments. On sheet1 I have set up formulas for the user to input their monthly points data, and my formulas use this data to calculate the corresponding funding achievement in Column P...

I have this code which filters for "RET" and then goes to next active cell. But in case "RET" is not found in the list, the next active cell will be blank and I want it to do nothing and continue on another part of the code and if it is not blank I want it to replace "RET" with 0...

Hello all! This is my first question ever: I am writing a code in which I use autofilter for option "RET" but in some instances that variable is not present. How can I ask VBA to do nothing if the active cell is blank and to continue with the code if the active cell is not blank...

Hi all, I have the following bit of code that supplies a time stamp in column Z when the cell in column G is populated: If Target.Column = 7 Then Application.EnableEvents = False Cells(Target.Row, 26).Value = Date + Time Application.EnableEvents = True End If I wanted to bypass...

hey guys what i have .. A column with some task where they are update by the days when they are done. I want to create barcode with those task ... I mean when i read the barcodes it will set the task as done and change the date of the cell for today ( day when was done the task). what i did...

Hello all, Is there a way to set up an ‘IF’ formula that when condition is not satisfied the result is ‘do nothing’? (it doesn't have to be IF but it does need to be an in-cell formula) Normally you would have something like - =IF(A3=3,"Yes","No") - obviously this basically means...

I am trying to get my macro to do this on open. Check if a1 is empty, if its empty run another macro (which is an input box to put something IN a1), but if A1 has something in it, DO NOTHING. I keep getting errors, saying I'm not formulating my if statements correctly. :confused: This is...