I have a main spreadsheet that houses many links to many other spreadsheets. Some of the other spreadsheets have not yet been created so they literally do not exist. I'm using the code shown below to update those links in the main-spreadsheet and that works perfectly fine but when it gets to the...
That I did not know. So, when you have both workbooks opened the formula works for you? I still get the #REF!, I guess I'll have to come up with a plan-B on this... thanks for the Hui
Thanks Hui... I do completely understand your formula and it seems like it should work but it's not working for me, it's returning a #REF!. I tried a few tweaks but no change, what am I missing, do you have any ideas why it's not working for me?
I’ve attached two workbooks, we’ll call the 101A-000 the data file, the 1422A-000 has a reference to that data file. I simply want to create a formula in 1422A-000 that will update based on another cell, you’ll find more explanation on that in the spreadsheet. Thank you for looking and I greatly...
The code below deletes conditional formatting in the entire row if "OPEN" appears in column-C, I'm trying to figure out how to get it to delete only in Column-D. For example, if C5 and C8 are the only ones that have “OPEN” in them then CF would be deleted in only D5 and D8. Any help will be very...
This code checks cell B5 for a hyphen and if it’s there then it displays Commandbutton2, works good. I'm looking to modify it slightly so it looks in the entire column or a range like B5:B24 for example... thanks for looking, any help will be very appreciative.
Private Sub...
VBA code converts the cell from formula to value. This is done to lock in the date... keeping the formula in tack will result in it continually updating to NOW(). Something I just discovered, if I open GraH-Guido's workbook the conditional formatting as he has it does work on my home Office 365...
David… what you describe is exactly what I’m shooting for. With the formula in column-D, when I select OPEN I get black font… should be red like you are seeing but it’s not.
GraH… altering the condition as you have it changed nothing for me, still no red. If I use the opposing formulas I get...
I feel like a deer staring at headlights, I think I need a different set of eyes to look at this, what am I not seeing here? I'm using =ISFORMULA(D5) in a conditional format which should result in the font in the entire row to go red as long as D5 has a formula and then go Auto(black) once that...
OMG Kenneth, that was painless. You made something that I thought would be nearly impossible to do look incredibly easy even though to me it looks outrageously complicated. You should get an award, I can't thank you enough, this is the coolest VBA thing I have ever seen, Excel talking to my cell...
The idea is to click on an Excel ActiveX button that houses VBA code that sends a text message that reads “You have a new request” to cell phone numbers 2623700361@vtext.com and 2623703023@vtext.com followed by an Excel MessageBox that displays “Your Request Successfully Sent”
Thank you for...