Results 1 to 2 of 2

Thread: Compile Workbook, ignore blank cells

  1. #1

    Compile Workbook, ignore blank cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All, I have been working on a code to allow me to compile data from may workbooks wit a VBA macro.

    The trouble is that in the set range there are many blank cells (the data varies in quantity each week).

    Is there a way to sip blank cells when compiling?

    Thanks

  2. #2
    I am also looking for an answer to this question. All I have been able to find so far is: rw = Range ("H45").End(xlUp).Row - 7

    My full range is A1 through N41. However, the amount of rows used will vary. If the H column is populated with a text value, I want the entire row to transfer to access using "objAccess.DoCmd.TransferSpreadsheet".

    I have figured out that .End(xlUp).Row is what condences the range to only the rows with values. But do I have the "H45" in the right place? and what does the "- 7" represent? How to I then get the code to Identify that I want column A through N of the row if column H has a text value?

    I think we are looking for the same answer itsmickeymickey.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •