delete a cell if no content

[PARSMS]

Hi
I'm a brand newbie on VBA
I have a workbook called "input" that retrieves information from other workbooks (a,b,c) in a excel spreadsheet, if column G, in each workbook has content

on workbook "input", each column has the content from workbooks a, b and c when column G in that workbook has content

therefore I have lots of lines in each column that come empty, that I would like to eliminate

how to do it?

many thanks in advance for the support
BR
Paula

 

[My Aswer Is This]

So which columns do we need to search.

Is it column A B and C

And delete any cell that is empty

 

[jproffer]

This will delete blank cells in columns A:C:

Range("A:C").SpecialCells(xlCellTypeBlanks).Delete shift:=xlUp

or you can do it manually...select columns A:C --Home Tab--Find and Select--Go To Special--Blanks--OK...then right click and delete them and shift them whichever way you like...I'd assume up.

 

[My Aswer Is This]

Try this:

Sub Delete_Blank_Cells()
'Modified 6/21/18 6:00 AM EDT
On Error Resume Next
Dim Lastrow As Long
Dim i As Long
For i = 1 To 3
Lastrow = Cells(Rows.Count, i).End(xlUp).Row
Cells(1, i).Resize(Lastrow).SpecialCells(xlCellTypeBlanks).Cells.Delete
Next
On Error GoTo 0
End Sub

 

[PARSMS]

So which columns do we need to search.

Is it column A B and C

And delete any cell that is empty

hi
lets try to say it in a different way
if a cell on column G, in workbook A has content, this content will be shown in Column A in workbook "Input"
if a cell on column G, in workbook B has content, this content will be shown in Column B in workbook "Input"
if a cell on column G, in workbook C has content, this content will be shown in Column C in workbook Input

then, I will have empty cells in column A, B and C on workbook "Input" and I want to delete those

did I explain myself better, this time?

many thanks in advance
BR
Paula

 

[jproffer]

Did you try the codes provided? His is more complete and ready to use as-is, but both do the exact same thing because "SpecialCells" whether done manually or by code, only takes into to account the used range of the worksheet (or in your case the used portion of columns A thru C).

 

[Fluff]

How are you populating cols A:C on the input sheet?
Formulae, macro, manual copy/paste?

 

[LFKim2018]

just passing through...
your code for this worked perfectly.
I can use this in my project.
Thank you