cname

I have a code that worked for years, but all of a sudden it does NOT. Not even the backups that I save. This leads me to believe it is something on my machine or an Excel update I'm unfamiliar with. BUT, it is a hufe pain and I can't figure it out. The code populates a listbox. (I have another...

What’s wrong with my code? Each cName is found on each sheet and the Delete procedure is performed. (as witnessed during debugging) However, only Sheets(“Net”) and (“ADJ”) Ranges actually get deleted. Identical code for any sheet between (“Net”) and (“ADJ”) the Range remains. During...

Hello experts, not sure why this doesn't work but I want to activate a Worbook that I opened via form after the form closes but it doesn't do anything. My Code Private Sub OpenButton_Click() Dim CName As String If Country.Value = "Abu Dhabi" Then CName = "C:\IC\Intercompany Recs Middle...

Hi trying to utilize the following code but seems to be hitting a bug somewhere Issue 1. The code is meant to be executed by pressing a button. Which is on Sheet 2 and the page that gets PDF-ed is Sheet 1. The code works perfectly for this part but saves it in random folders depending on where...

Hello Experts - I have below code which transfers the file (Gross Contribution Report) inside the subfolder (and override the same file inside this subfolder). However, nothing is happening whenever i'm running below code. Can someone help me understand what's wrong. For visualization purposes...

In Excel 2013 from Office 365: Problem: I lose combo box functionality when I protect my worksheet. Current solutions I've attempted: I am using an active X combo box for a drop down list using data validation with a named range (CName). The named ranged of the data validation list (CName)...