I am try to get a code to hide cell range or Columns but I can not get it to work in Office 365. and trying to tide it to a button
Sub DoIfNotEmpty()
Dim ra As Range, re As Range
With ThisWorkbook.Worksheets("Sheet1")
Set ra = .Range("D4:F40")
For Each re In ra...
Hello,
I use the below code for my absence tracker which was kindly provided on here.
I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at:
Current 6 months Tab - All absence in the last 6 month rolling period from...
hi
please use the version1.7 to add the vb formula in it.
in modmain vb script
hi
i need to add a vb code in by vb script below
eg-
1.data is in c1 out put to c3.,after first 2 digits the following 4 digits
c3 =mid(c1,2,4)
2. data in c9, and c16 ,“open and Closed inverted...
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.