Hey everyone,
I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot!
Besides the...
Hello friends,
I have a problem that needs help:
- I use Windows 10, while running ABC.xlsm, the screensaver and login screen with the PIN pop up.
- I want to have line of code D so that ABC.xlsm automatically fills in PIN (fill at the time of having code D)
Thank you for all the help and attention!
Once in 3 or 4 code runs, excel is crashed with that strange, tough error message about Error in data connection (can’t connect). Code is extremely simple (crashed at the last line):
Set wsS = Target.Parent
Set rng = wsS.Range("B3:F186")
Set d = wsS.Range("G3")
rng.Copy
d.Insert...
March 2018 Windows 10 update has scrambled Excel 2003, both the spreadsheet and also the vba. I use vba, among other things, to 'compile' javascript into closure-compiled form. It appears to have lost the ability to understand classes. For example, I have a js class which includes...
I have a small pest control & termite bonding company. We have yearly renewals for the termite bonds. I have a worksheet with 12 (monthly) sheets. Each sheet has the same table with the same headers. I need to combine the worksheets into one master table that automatically updates if we were to...
Hello Fellow Excel Users,
I have a computer dilemma that I am hoping you can give me some advice. I have a Excel macro that analysis a data file and generate 18 or more graphs. It works, and a thank you to all who helped me from this forum, but does take about 8 minutes to run. I will run...
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.