fails

Dear all, I have written some code to save an excel sheet as a pdf (WIN 10 using MVB for Applications 7.1, Excel 2013). Stepping into the code executes perfectly but when I assign the code to a command button or form button the code fails. It seems to fail at the section starting at...

Hello everybody. For one specific site, I've problem in logging in. When the macro runs, the id is correctly written in its field, the same for the password, but clikking the button the operation fails with the following alert as if nothing had written: All fields are mandatory...

Hi All, I'm trying to resolve a nested IF in excel, or IFS. Which ever is easiest. I'm trying to get the following idea to work...

I've used the Convert function many times. For some reason, it fails when I try to convert miles/hour to meters/second: <tbody> R/C C D E 4 mi/hr m/s formula 5 60 #N/A D5: =CONVERT(C5,"mph","m/sec") 6 60 #N/A D6: =CONVERT(C6,"mph","m/s") </tbody> Now what am I doing wrong? The 60s in...

C4 needs to have the total sum of all Values from J16:J200 that have the value in B16:B200 that is equal to A4. Example: Because A4 is RK and B16 is RK, C4 will equal $250. IF I add a new row and B18 is RK and J18 is $250, then C4 will be $500. Thank you for...

Hi, I am trying to collate a number of different spreadsheets using VBA to achieve a complicated layout. The following code exert should find a string within a calculated range: sDate2 = wbFMPPrevious.Worksheets(wsDestination.Name).Range(Cells(nPrevAvail + 2, 1), Cells(nPrevAvail + 11...

I'm trying to run code on a sheet while my form is still open. I have simplified this code a lot to isolate the issue in the simplest form. I have my main macro launching the form, and vbModeless seems to do nothing for me. Then when the DropDown list is changed, it runs another macro while the...

I am using Excel 2013. I have a listobject excel table called Assembly I need to find the cell that contains "asmb1" in column "Item Name" Here is what I have that does work: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit...

Hello, I am new to the forum, and hope someone can help. I need to create a "dashboard" for my end users that will automatically return a result like my sample below. <tbody> A B C D Over_4_Years Over_6_Years Over_8_Years 1 Salary_3 70,000 72,000 74,000 2 Salary_2 60,000 62,000...

First time post. Please excuse any indiscretions. ' I want to set Selection.Font.Color using RGB values, which are stored in a cell in a different worksheet ( e.g., RGB(0, 102, 204) ) ' Here is some of the code Dim DataWorksheet as String Dim SelectionFontColorCell As String Dim...

I am a very experienced VBA and Excel programmer. I have been using Excel 2003 and have an extensive add-in library, that I use Lorent Longre's free UDFCustomize.dll to automatically load a custom function category and provide the links to Help. My add-in functions look like and behave like any...

I've recently received an upgraded computer at work. Yay! However, it's running Windows 7 and several of my applications are not working properly anymore. resultsSheet.Rows("11:" & maxrow).Select is the statement that fails. I need to select all of the data from row 11 down and create a...