Hi, I'm trying to get the following to work: It doesn't seem to like the line: objExcel.ActiveSheet.Columns("D:D").SpecialCells(xlCellTypeBlanks).EntireRow.Delete Is there something wrong with it? Set objExcel = CreateObject("Excel.Application") objExcel.DisplayAlerts = False strWB = "C:\Test\admin ...

Hi,

I have columns in one excel workbook and I need to move them to a 2nd workbook. Would it be ok to use the internal VBEval>GetCell() to do this?. The cells are e3 to e30 and some different in other columns, is it possible to copy e3-e30 using VBeval>GetCell?.

Thx,

John