Solved

# Macro Excel VBA to verify if cell not empty

Posted on 2014-12-30

Hello,

I need your help in order to:

verify if the cell A1 is empty, if not, apply the vlookup function, if yes, stop.

Not to sure how to explain. Column A has around 23000 cells with data (next month it could be more, it could be less).

Column B should is a vlookup result if cell A is not empty: if cell Axx not empty, then apply the vlookup, else, nothing

I need to repeat this for many column... check if cell A is empty, if not the apply the vlookup, else, nothing...

Is this possible? I am trying to automate as much as possible an Excel Spreadsheet that will, at the end, create a "Table" will all pc information i need from different CSV files.