Search results

See the attached worksheets. WS-01… A1 has an entry of $100 WS-02… A1 has formula ='[WS-01.xlsx]Sheet1'!$A$1 WS-03… A1 has formula ='[WS-02.xlsx]Sheet1'!$A$1 All worksheets are setup to “Don't display the alert and update links” When I change to $200 in WS-01, WS-02 also changes to $200 but...

Here's what I pieced together, it works but is a bit long. The seven lines of code starting with the line that begins with "WO" are repeated for each cell in column-C that could potentially have a hyperlink, so the entire macro is 338 lines which isn't really much of an issue for me, on the...

Looking to send to a physical printer

I may be asking for a bit of a magic trick here. I have a worksheet that has hyperlinks to other workbooks. I’m looking to create an ActiveX command button to print the active worksheet and all the hyperlinks in column-D. The linked workbooks and the number of hyperlinks is not static, so the...

Chihiro... thank you for the suggestion. The problem is that P1 has the validation formula =INDEX(INDIRECT(O1),0,1). What happens is P1 is looking to O1 to figure out what list is should be using, so when O1 equals N/A then P1 looks for the list called N/A which does not exist and what I found...

Not sure if this is possible but it’ll be interesting to see if it is. In cell P1 I have this List Validation formula that does the job nicely. =INDEX(INDIRECT(O1),0,1) Here's the List Validation in O1...

Here it is... works great Dim r As Range, rr As Range Set rr = Selection For Each r In rr r.Select Application.SendKeys "{F2}" Application.SendKeys "{ENTER}" DoEvents Next

I have a group of cells N6:N37 that need to be refreshed in order for the formulas to produce a return. This can be done manually by the key strokes F2 followed by the Enter key. I have been trying to create a macro like the one shown below but it does not work and might be a known Microsoft...

UPDATE... it looked as if this was working, it runs through the code without errors but it's not updating the links. Can anyone see what I'm missing here, I sure can't. Private Sub CommandButton9_Click() 'Update Petition Links With ApplicationFileSearch LookIn = "H:\Public\Quality...

Khalid... wow more wizardry and another excellent solution that works perfectly. Chihiro did teach me about CTRL-SHIFT-ENTER Array function which is new to me and good to know, on the other hand ENTER is simple in comparison. I like it because my human RAM isn't what it once was so in this case...

Belleke... I did get your doesWEexist code to work, had to tweak it a bit because of this https://answers.microsoft.com/en-us/office/forum/office_2010-customize/i-have-a-spreadsheet-which-uses/669118de-e3a5-4815-bb95-0a83eb6bf984?auth=1 I really appreciate the help, thank you

I have a main-workbook that has hundreds of links to sub-workbooks. The sub-workbooks get created daily so their quantity is always growing day by day. The main-workbook already has all the links to the existing sub-workbooks in it and also the ones that have yet to be created. I'm using the...

Chihiro... that looks like formula wizardry to me. That Array thing is like I just learned a new magic trick. In a single wave of your wand you have solved my problem, thank you, it works perfectly.

I’m using an INDEX MATCH combination formula; VLOOKUP doesn’t work because what I’m trying to return is to the left of the lookup. The formula I’m using works good except I’m looking to also have it continue down the list, skip over the one it just found and then find the next one and continue...

Wow you guys are awesome, great responses, let me address each one individually. GraH-Guido... I am also a bit confused and probably not qualified enough to completely answer your question about allowing and then not allowing. The formula in my original message does work but not if I include...

I'm using the formula below in a data validation and it works fine. It allows only numeric value entries with the one exception of an upper case "N/A". I've been trying to expand on this to also include the use of hyphens. So, legitimate entries would be an uppercase N/A or any number...

vletm... yes I can, very helpful, greatly appreciated and thank you.

I could use help with this, I've gotten the CommandButton portion to work but I'm stuck on the unlocking the range part, if someone out there could enlighten me I’d really appreciate it... thank you for looking Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Unlock L5:L6 when N5 =...

Thank you for your suggestions. I've been playing with this a bit because I'd rather not have a separate list or table to do this and the Worksheet_Change event I'm not sure about. So, I composed the data validation formula below which does work for "CUSTOMER" and "EMPLOYEE" because they are...

I have two cells that have the same entry possibilities from a validation list. I’m looking to avoid having the same entry in those two cells. Additional explanation is included in the attached workbook. Thank you for looking and the help is really appreciated.

The code below works fine, I'm looking to mask the password entry. I've researched the internet and found some postings that claim masking is not possible with an InputBox, does anyone know if this claim is true? Dim Pass As String Dim Prompt As String Dim Title As String Dim...

This is a different scenario… the cell in column-F is blank and locked to prevent premature entry prior to all other cells in the row being filled or in other words, column-F cell is the last entry in the row. So, what happens is your code above unlocks all cells in column-F that have the “!”...

Well chirayu, thank you again. Did you recognize that code, it was a portion of yours from a previous post. This one works just as good as the last one... very appreciative of your help.

I have this code that works great but I'm looking to tweak it a bit by changing SubRng.EntireRow.Locked = False which unlocks the entire row to having it unlock only the single cell in that row in column F... thanks for looking and I appreciate the help. Dim Rng As Range Dim SubRng As Range Set...

Hey p45cal… works perfectly, I figured it was something like that, I was trying this =INDEX(INDIRECT(J2,1). Thank you for the education, it helps me out a lot, I’ll be able to use this in several places.