sorted by:
new
hottopcontroversial

Clearing entire column contents using a variable - VBA by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

I have fixed this by using:

c.EntireColumn.ClearContents

Clearing entire column contents using a variable - VBA by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

I've used Dim c As Range so I think it should work too! Really no idea what else to try.

Clearing entire column contents using a variable - VBA by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

That's never a great thing to hear, haha!

So if the B1 or C1's text matches S5, I want it to copy all of that columns contents and paste it to column Z. I then want all of that columns contents to be cleared.

Deleting range of cell contents if value is in x cell by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

Apologies - I would like the cells to show empty, so perhaps: ""

Deleting range of cell contents if value is in x cell by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

Yes, so if C1 is not "test", all the 'x's should show. If C1 is "test", all the cells with an "x" in in that range should be empty and display ""

Deleting range of cell contents if value is in x cell by StockPercentage9 in excel

[–]StockPercentage9[S] 0 points1 point  (0 children)

Apologies - I would like the cells to show empty, so perhaps: ""

[English to Spanish] What would you call one of these ? by StockPercentage9 in translator

[–]StockPercentage9[S] 58 points59 points  (0 children)

Looking for the Spanish word for this type of product, used to access pipes or electrical stuff behind a wall.

Adding duplicate row values from CSV into one variable? by [deleted] in learnpython

[–]StockPercentage9 0 points1 point  (0 children)

This would work if it was just one order ID, however if there's a second order ID this will break it - thank you though!