I'm looking for a vba code that will hopefully delete multiple columns preferably (or ranges) based on a cell value (0 in this case).
What you see in the image is a front and back page.In my worksheet there are 40 pages but only need to print the ones that don't have 0.
In the scenario in the...
Hi Gurus,
I have some columns that I need to delete however, there are embedded picture image in cells.
I tried using below code but the picture are still visible.
= = = =
Sub Delete()
Worksheets("Sheet1").Activate
Columns("C:C").Delete
Columns("X:Z").Delete
End Sub
= = = =
Is...
Hi Gurus,
Good day!
I found below code in deleting specific column. However, I want to apply it for all tab sheets. Suppose I have 15 sheets.
= = =
Sub DeleteSpecifcColumn()
Dim xFNum, xFFNum, xCount As Integer
Dim xStr As String
Dim xArrName As Variant
Dim MR, xRg As Range
On Error Resume...
Pretty much what the title says:
Need a command button on a worksheet that runs code to delete all data in Columns A through D (incl) on "Sheet4" as a way to cleanse the workfile for additional data import.
Note that there are formulas on "Sheet4" in columns E through U that reference the data...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.