MS Excel / VBA help thread

You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.

•

greentricky

Edit to add.. why do people use macros when PQ exists within Excel?

I am stuck in the a place that still runs 2013 and won't enable add-ins, change to 365 tomorrow though

why do most people add black cell borders?

If it isn't a Table with banded rows and header, I use black borders for legibility if there are too many rows that make it hard distinguish reading across

Worth also noting just apply the conditional formatting to the specific cells in the table that need it, it will kill excel if you apply it to an entire column

Urgh, someone some how applied too much formatting to a spreadsheet this week and turned the file from 30mb to 400mb, contains around 60 worksheets as well, so was a nightmare to track down where the size had come from but turned out it was excess formatting on one worksheet in the end

•

NotThamesWater in reply to @greentricky

400MB of empty cells, you mean.

vis. macros:

Private Sub Workbook_Open()
    set myRange = all.of.the.useless.empty.cells.that.are.there.because.some.cunt.doesn't.know how.to.excel
    myRange.EntireRow.delete
    myRange.EntireColumn.delete
End Sub

MS Excel / VBA help thread

About

LFGSS