1. D

    Pdf to Excel using Word --> "wDoc.Tables.Count" not counting the empty column

    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...
  2. D

    XML Maps and Empty Tags

    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
  3. M

    Application.Match to find first Empty element in an array

    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...
  4. I

    VBA code to paste adjacent cell only when cell pasted to is empty

    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...
  5. I

    VBA Search Loop If Empty Copy Paste Next Help!!

    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...
  6. T

    Find Next Empty Cell

    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...
  7. A

    Loop through empty cells and data move to one cell left

    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...
  8. O

    Vlookup with variable lookup value

    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
  9. S

    if, or, and-formula issue

    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...
  10. T

    Formula for conditional formatting

    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!
  11. B

    Right to left counting cells with value until the first empty cell

    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 ?
  12. P

    Deleting Lines with a Macro Command

    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...
  13. L

    If cell is Empty!

    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...
  14. T

    Copy Active Cell Comment to next empty row on another worksheet

    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?
  15. B

    calculation without Circular reference

    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
  16. I

    Show userform based on cell value

    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
  17. L

    VBA Help Delete Row if 3 conditions met?

    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...
  18. F

    I Just Don't Get Nested IF Statements

    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...
  19. M

    Conditional Formatting (I think

    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...
  20. T

    How do i get this macro not to run if target is empty or 0

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back