Tag Archives: vba

VBA delete row if cell is empty

Posted on March 2, 2014 by LZH

The below code lets you find the last row and look into the range of cell if it is blanks. However there are instance where the lastrow might be error prone as this doesn’t tell you FOR SURE the last … Continue reading →

Posted in vba | Tagged , | Leave a comment

VBA Copy and Paste Cell as Value

Posted on March 2, 2014 by LZH

Here is how you can paste the selected data as value in Excel VBA. Below are the other possible paste special method in vba.

Posted in vba | Tagged , , , | Leave a comment