I am trying to use the following to print a multiple page worksheet.
Can not figure out what my error is.
Sub Set_Print_Area()
'Unprotect Worksheet
ActiveSheet.Unprotect Password:="XXXXXXXe"
'Set Print and Review
Dim c As Range
Dim FirstAddress As String
Set c =...
Unsure why I receiving a Run Time Error with the following code. Any help...
Thank You
With ActiveSheet.Range("A1:c25")
Set c = .Find(2020, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Value = "Replaced"
Set c =...
Dear Excel users, I have a problem to auto filter a predefined list in a combo-box. I have two comboboxes on a Userform - the first one calls up job numbers (Reg5) and the second one calls up activities (Reg6) that is related to whatever is selected in Reg5. Because the list in Reg 5 is massive...
hi
I'm doing my job using the code below
But In fact, the words (keywords) I want to delete are in the column "c"
I mean the keyword is not just a word
I have a lot of words in the column that is added to them daily.
Is there a friend who corrects my code according to the image.
thanks...
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.