empty

Hi Everyone, I have this macro that works great but I need it not t run if the cell I secect is zero or empty. how can I do this/ p.s. if my code can be improved feel free to go ahead and change it :-) (Columns E & F are merged per row so E88:F88 etc.) Thanks Tony Private Sub...

I had data from A to T I want to check the entire column of D, if there is a empty cell. Marco will aborted. MsgBox "Pls ensure Col D is not empty"

Hi. I use the blow code to paste data from a textbox in a user from to a specific cell on sheet 1. I would like to refine this to: Paste to the active worksheet, instead of just Sheet1 and Paste to Cell N15 (of active sheet), only if empty. If not empty check if N25 is empty and then...

Hey all, I have a Userform with textboxes in it. A user can input up to two characters in each. How the values are formatted is dependent on how many characters there are i.e. Empty Textboxes are handled one way, single characters ("A") are handled another and 2 letters ("AB") are handled a...

Hello all, I'm trying to write an IF state for a situation i'm looking into. I have a Cell AQ3 in which i'm entering an if state. Here is the criteria for the if state. 1) It checks if a date stored in S3 - Today() date <> 0 2) It checks to see if cell AG3 is empty Now the issue here is...

Hi Everyone, Heres my problem, I need a macro to do the following. Copy Range AX53:AY68 Then paste to the first empty column row 53 after BK So First Column it could past into is BL53 if that already contains data move on to BM and paste in first empty cell Please help if you can thanks Tony

The formula below works but returns 0 when B2 is empty. What I'm trying to do is if B5 contains data then copy B2 only if B2 also contains data, if B2 is empty I would need the cell where I have the formula to stay blank too and not show 0. Thanks

Hi, I am trying to find a code which will select the next available empty row down the spreadsheet and then select columns A to D of that row. Could anyone help me out with this please? Many thanks

Hi, Please I want a formula for this excel sheet: https://drive.google.com/open?id=1uEnW5zXiEW6cYLrFqew8S8soTvsCruej If possible I want to know the exact numbers in all empty cells from H5 to H79, I5 to I79 and J5 to J79. Thanks in advance.

hi, every one i have data in sheet1 begins from a2: f38 the empty data begins from a17:a32 i just would code print the filled data and ignore the empty data if a17:a32=""

Hello guys, i have a file that i only want to be editable by user forms. For that result i protect the sheet and unprotect it only when running the macro. But users are still able to browse through the data, copy it. Most of the time they will edit specific places by copying and searching via...

Hi there! I have some problem and I will wonder if you help me on this. I have a calendar with 12 command buttons with name month_1, month_2 , ... ,month_12 and almost 365 command buttons with name day_1_1, day_1_2, ... ,day_12_29 and also 365 cells in a separate worksheet relative to this...

Hi I have a pivot table on sheet 1 and would like to paste values to the next empty row on sheet2. I need a macro that will select everything but the header on line 1 and grab the data on the table and paste to the next empty line. Thanks. This is what i have so far, but it writes over the...

Hello Friends, I have a complex problem that I need to solve. I would like to have the following results: Column A has 5 digit numbers. Of all the numbers that are consecutive in column A, I would like to have all of the digits that are consecutive deleted and print only unique...

Hi all I want to delete contents of a sheet based upon some criteria. I am very basic in VBA. I created Select and ClearContent by recording macro. :) But, I am not sure how to add criteria. Here is my code. Sub DeleteData() ' If B3 is not empty and not equal to ""...

I have a reservations spreadsheet that I need to transfer data to to another sheet if a cell is not empty using an ActiveX button called TransferNoShows. I need the following to happen when I press the button: In Spreadsheet 1 If a cell in I3-I39 is not empty Transfer (append) Data in Cells...

Hello this code executes and does what I want to if there is text in the cell. It is still doing it if the cell is empty and there is a formula in there. Any ideas how to adapt it so that is ONLY executes when the cell is empty? If Not IsEmpty(Cells(ToRow, "E")) Then Thanks.

I have a table that was generated from an update query. The table is just one column containing either numbers or just being empty. They are also sorted, so the empty cells are on top, numbers are sorted. Numbers range from 1 digit to 5 digit numbers. I open the table in Design View mode...

I am looking for a formula in cell A2 that takes the amount in cell A1 subtracts cell B1, subtracts cell C1 then adds cell D1 displaying the new total amount, however if cell B1 is empty them cell A2 will not show anything.

Hi Everyone, I want to be able to open two XLSM doc from a folder. The Two File Names are in sheet "Welcome" Cells "B11" and "B12" but don't or might not have the .xlsm ending. the filepath is in cell B10 and will look like this "C:\Users\Tonypc\Downloads\New folder" I would like to first...