empty

Hi, I have a userform with text fields and checkboxes. The data entered in the userform will be transfered to a new row in the named table "tblColleagues". This table already contains a few rows with data but the named table range also covers lots of empty rows. How is it possible to make the...

I have a code to Export/Copy Data from Pdf to Excel using Word. (I have included the code below) So the code should create a Word file and import the selected Pdf file and copy every page as a table to word and then to excel. the code should run with in "tbindex = 0 to wDoc.Tables.Count" Range...

This is part of my xml I can map everything just fine except <Lost_agreement /> After i export mapped XML, <Lost_agreement /> is missing. it becomes But <Lost_agreement /> part is crucial and must be. How can i achieve it? Quote Reply Report

Hello everyone, Can I use Application.Match to find the first "Empty" element of an array ? Please refer to the below code, looking at the Locals window, once the array is created, all elements of the array have "Empty" value so the first debug.print give Error 2042 as I was looking for the...

Hello. I have this code that compares two columns between two sheets. It matches the values in column J in “Ships” with column M in “Main”. It copies the value 10 cells to the right from sheet “Ships” and pastes it in the 3rd cell to the right on “Main” sheet. However, I need it to only paste it...

I am in VBA H**L right now. Here is what I need the Search Loop to do. In Column A cell "A2" is a changing value depending on the person selected. This is basically a RecordId column. Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain...

Hello, I have the following code: Sub EmptyRow() On Error Resume Next Application.Calculation = xlCalculationManual Application.EnableEvents = False Application.ScreenUpdating = False Dim wbCurrent As Workbook Dim wsCHINO As Worksheet Dim wsSTOCKTON As Worksheet Dim wsFLM As Worksheet...

Hi All, Loop through empty cells and data move to one cell left <tbody> Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date...

Hello, Is it possible for a VLOOKUP to have a multiple lookup value. For example: =VLOOKUP(A1,'Data'!$A$1:$D$1000,2,FALSE) If the lookup value in A1 is empty it can look at a different lookup value in A2? Thanks in advance, Chris

Hey All, I am scratching my head trying to figure out where i am going wrong, looking for a cell to return '1' or '0' based if certain combinations of Yes/No and Blank cells are selected for the logic. Formula i have now is below, but this issue seems to be that it is not working for the if...

I'd like to highlight a row based on certain criteria. Say for example in row 7, if C7 contains the word "checked" or its empty, and if D7 contains the word "checked" or its empty, and if E7 contains the word "checked" or its empty, then i want this row to be highlighted. Thanks in advance!

I'm looking to count from right to left counting the number of cells with a value until the first empty cell. All cells are formulas. The range is set D:Y. I need to count cells that are greater than 0 until it reaches an empty cell. Can someone help me out with this ?

Hello guys, I have an excel file with some records that are copied/pasted from a website. Due to the site's structure when I paste the data on excel, some cells cause the line to split (see an example below) and the surname of the person goes to the below line which except this cell all the...

Hi all, I am trying to check for all sheets if specific call E10 is empty and it prevents user from saving. Currently it is only working on the sheet that i am on. It does not work on the others, i want to make it that it checks all check for a specific cell before saving. This is currently...

I am trying to find a way to automatically copy any cell comment from worksheet1 in range H7:H5 as text to the next empty row on worksheet2 Is there any way to do this?

Have a question if I may, I want to use two adjoining cell;let say C3 & D3 and I would like to be able to put a figure in either ofthese and have the empty cell calculate either way. How can this be achievedwithout causing a circular reference? Steve

Currently not at my pc but I would like a userform to only be shown if a specific cell is empty. Would this be correct ? Please advise. If Cell (“B1”) = “” Then Userform1.Show Else Exit sub

Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row. In the example below row 8 would be deleted as AI = 0...

3 columns 1 row: $X1 $Y1 $Z1 If there's a number in any of these, l want to trigger a concatenation involving the data in that specific cell. The row will be filled in left to right. So, if X1 is empty, then Y1 and Z1 will be too. If Y1 is empty, then Z1 will be empty too, but X1 may have...

Hi All I need a really simple way to highlight a cell based on the contents of another - but am getting confused. In short - I need cell B9 to highlight red when: B9 is empty and N9 has data. Also, I would like cell B9 to highlight orange when: B9 has data and N9 is empty Both B9 and N9...