Search results

On this 64-bit machine we are running Office 2010 32-bit and the patch you suggested is already installed. I ran the code on Office 2014 64-bit and it works great, unfortunately that version is not available to me... any other ideas around this dilemma?

Need some guidance here... this all works well except for the code between Dim wks As Worksheet thru Next hl, however that code does run fine by itself without all the other code in the macro, what am I missing? Sub MoveLineItemsToShipped() Selection.Cut Sheets("Shipped").Select Dim...

Looks like you are correct, it works fine all by itself... here is where I get into trouble because of my limited experience. I have included the spreadsheet, take a look at the MoveLineItemsToShipped macro. Basically the way this should work is after selecting rows from the Open tab, the macro...

Hello there... can anyone tell me what I need to do to get this to work in Excel 2010, it works fine using 93-2003... thanks Sub FixHyperlinks() Dim wks As Worksheet Dim hl As Hyperlink Dim sOld As String Dim sNew As String Set wks = ActiveSheet sOld = "2014" sNew = "2015" For...

Luke M... works perfectly, your comments explaining the code is very helpful to my VB evaluation, another piece of the puzzle in place... thanks again

Luke M... I will heed your caution, thanks for pointing that out, that code was something I found on another web site. As for your code, I can see I made this a lot more complicated then what was necessary; your code is much cleaner and works perfectly except for one small issue. In your...

I think I’m real close here but there is a problem I haven’t been able to figure out. What should happen is when I check the checkbox the macro should look in A1, if nothing is there it should simply shutdown and change none of the checkbox properties. When a date is entered in A1 and the...

Never mind, I just answered my own question... thanks again

dEEPAK... you make this look easy, I wish I was so smart, the code works perfectly... many thanks. QUESTION: You suggested that I tag the code... is that done with a "" at the beginning and a "" at the end?

After a few days of trying to make this work I find myself back here in need of help, I just don't know enough at this point. I found this code on the internet and have been attempting to alter it. It works but not exactly the way I need it to. What it does is create a shortcut, the part I'm...

dEEPAK... the code is much more sophisticated than what I was looking for however still very helpful, it did provide the guidance for me to figure out how to get what I needed... thanks for your help... Dennis

At the end of my macro I have the code shown below. What it does is save the file, displays a message to create a shortcut and then closes the file… it works great. The question… is it possible to add code that would also create the shortcut (LNK) file rather than having to do it manually...

Very helpful... thanks

I did finally figure it out. Just a note, the reason I asked about changing the <=0 was because I was stuck on how to go about changing it to be =0 and/or blank. You are correct that the =0 part is logically, I was not sure how to incorporate the blank part... thanks for the help, Dennis

I have this macro that works perfectly except that it saves my macro enabled workbook (xlsm) as a regular excel workbook (xlsx). Can someone tell me what I need to change so it saves my macro enabled workbook as a macro enabled workbook? With Application.FileDialog(msoFileDialogSaveAs)...

Hi there Smallman, Looks like I made a bit of a mistake, I said "if the cell is <=0", this is wrong, it should be if cell A is blank or =0... sorry about that. Also a question, in the first line of your code should A17 be A18? Thank for the help... Dennis

I seem to know just enough to not get an error on something that doesn’t seem work. I’m looking for the macro to… look in cell A18 then if the cell is <=0 then ClearContents of cells A thru V... then look in cell A19 and so on. Dim MyRange As Range, UsedInRange As Integer UsedInRange =...

Narayan, Halleluiah, I finally was able to test your CL formula… I’m blown away, that is some sophisticated Excel wizardry you did there… you are the Grand Master, the Picasso of Excel, it’s like intellectual art, very impressive… oh one other thing, it works perfectly. Thank you, sincerely…...

Narayan, Something came up and I had to break away from this project momentarily, I'll update you as soon as I can test your new CL formula. Dennis

Narayan, I'm starting to feel like a nuisance, sorry about that. Please see U19 & U20 of the attached file... the combination of the four CL's did not produce is issue. Dennis

Narayan, Sorry for the delayed response, I’ve been try to figure out what’s going on at this end, here’s what I’ve discovered. If you can believe it I’m still on Excel 2003 so I’m not able to see all four of your CF’s; I will upgrade as soon as possible. I do currently have access to a PC with...

Narayan, Sorry I should have told you... the text "Reject" is manually typed in column S and only appears in S & U, it never appears in F... see the attached file Dennis

Narayan, If I'm understanding this correctly I'd say 1 and 3 together, that is if this means the formula will look for Angle, then when not found will look for Surface, then when not found will red fill the cell if the number in U does not fall within the range of Q*25.4 - R*25.4. Another...

Narayan, We are close, the “Surface” formula works perfectly as demonstrated in rows 26 thru 28. If I change U7<Q7,U7>R7 to U7>Q7,U7<R7 the “Angle” formula also works perfectly as demonstrated in rows 8 thru 10. So the only thing left is to integrate the 3rd rule that says if the 1st and 2nd...

Good morning Narayan, I have attached the spreadsheet and applied your CF formula to the U:V column, U8 is an example of the first rule, U28 is the second and U10 & U14 are the third. None of these should be red filled, I may have explained the goal incorrectly, and in addition I found an...