delete blank

Hey, Fairly new to this so any help is appreciated. We use excel to run graphics on a OBS System for a money exchange company - issue being OBS only likes to use "text" formatting, not number, currency or even general. We show a lot of currency on the the screen that we copy from various...

Good Day, I am working on a automated handover code to send an mail and all is working perfectly. I would like to move the active cell to the next sheet after the last row there and then delete the blank row as well. I have tried different examples from the web but with no luck Sub...

I have a macro that deletes all blank rows in Column A. It seems to only work on the Active workbook or Active sheet, and I would like it to specifically run on Sheet1 regardless of what sheet I am viewing. The name of Sheet1 is "Import" if that matters. Any help would be greatly appreciated -...

I want to delete an entire row if there is info in column A and column C is blank. Sub deleteBlank() Dim Lastrow As Integer Lastrow = Range("A" & Rows.Count).End(xlUp).Row Range("C2:C" & Lastrow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub When I ran this...

Enigma: there are cells in my workbook that are "blank" even when you hover the mouse over the cell the formula bar is blank. However when I print the page I get 8 blank pages. When I go to print preview the cells are blank but excel thinks that it is used so it is not blank. when I use formula...