idea

When file open, msgbox asking "This workbook contains links to one or more external sources that....." I searched for .xl in formula and found non. any idea where I can find external link and delete?

Hi I trying to understand how to call functions which return value and that which do not. I thought msgbox is a function that return value, so I tried to assign that value to a variable x but when I msgbox out x the value of x was 1? Any idea why. Thank you so much. Sub wk_open() Dim x As...

I am using this code to try and format a number like this 12-345-6789 but for some reason it’s not working any idea? Private Sub nsn_Change() If nsn.TextLenght = 2 or nsn.textlenght = 6 then Nsn.text = nsn.text + “-“ Endif End sub

IF [A]='4' AND [D]<>NULL AND ([X]='F' OR [X]='D' OR [X]='G' OR [X]='B' OR [X]='D' OR [X]='R') THEN [ID] END Any idea please?

Hello! I have data in three columns: A,B,C and each columns has several rows with numbers. I want to return all the A numbers that match: B= 4 or 3 AND C = 5 Any idea? I have been browsing through several websites but most at horrible in explaining bit by bit the formulas. Thanks!

Hello, I have a giant file that I am trying to use VBA to quickly work through. In column D, there are ~4500 unique identifiers. Somehow, i need to copy and paste those 4500 identifiers in the cell B1. Any idea how to code this on VBA? EDIT: Sorry to be clear - i am trying to find a way...

Hello Guru(s), In previous version of Excel, you could edit the format of a note to show a picture by changing some settings in the format/fill tab. This latest Jan 31st 2019 release seems to have removed this nice little feature. Any idea how to do this now? Basically any way for a picture...

Morning all, I have a macro button that when pressed creates a PDF of the worksheet and attaches this to email (Outlook). However, is it possible that upon pressing this button there is a way that the email can be automatically sent in the background? I'm not entirely sure if this is...

Hi all, How do I add to this formula =IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W","") It looks in the Monday range for a match with B2 then returns "W" but if false I would like it to carry out another formula to find a match but return R as per below, any idea how I can do this...

Hi, A user is having issues trying to open a file with the below macro code. I don't believe this is an issue for anyone else. The code and error are both below. Does anyone have an idea of what this relates to? Thanks in advance Ryan Private Sub Workbook_Open()...

This test formula works correctly USING ONLY 1 COLUMN: AC9:AC208 =SUMIFS(Z9:Z208,AC9:AC208,DV15) However, I have 2 sets of columns non contiguous: AC9:AW208 and CD9:CX208 This is an idea of what I'm trying to achieve: =SUMIFS(Z9:Z208,AC9:AW208,DV15) + SUMIFS(Z9:Z208,CD9:CX208,DV15) Much...

Using Office 365 Excel I enter into Immediate BoxDir ("E:") and I get back "180601 Temp RIBBON CALLS.BAS" which isn't even a file in E:. I add Dir ("E:*.*)"and I get bck the same thing. If I useDir("E:*.Bat") Nothing shows but there is one "*.Bat" file in the directory. Any idea of what's...

Hi all, Hope You can help me. I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas. The idea of the table is: <tbody> A B C D E F G H I J Name 1 V V V V V V V V V V Name 2 V V Name 3 V V V V...

Hi, Can somebody please help me I am having a mindblank. I am trying to show an address in one Cell (Full Address). Theaddress is currently spread over 6 columns. example below Thank you in advance <tbody> Full Address Address 1 Address 2 Address 3 Town County Postcode...

I have a VBA form that gets information from a worksheet and populates into the text boxes of the form using the control source property. Once I run the code, the formulas that were in the cells that the form gets its data from becomes the result of the formula:mad: and when I run it again the...

I got an idea but none on how to do it. Rather than scrolling thru 20-30 sheets in a work book looking for one in particular, is there a way to create a filter that will list all the sheets alphabetically and let you choose which one to jump to?

Hello guys, I'am really fresh on excel and I have an assignment to do. The task is to take an option from a dropdown box, insert your name, surname,your phones number click a button and it should move everything to sheet2. I honestly have no idea how to code the buttons and I hope someone could...

I have a list of strings and numbers that go with them. I'm sending the string to a Function to return the Number and was using Select Case but have an idea there's something better. I tried Enum. Can I use the variable name though, or must be a literal ?

Hello, I want to search and replace the following: =MAX(some-function,0) with =some-function I tried to search for MAX( in order to delete it (and then I would delete the ,0) part but it does not work! Any idea? Thanks!

Hi I'm trying to use a filter on a number of cells and want the value to update, I originally had =SUMIF(BJ8:BJ202,"Yes",O8:O202) I have this formula but it returns zero value, any idea what is wrong? =SUMPRODUCT(SUBTOTAL(9,OFFSET(BJ8,ROW(BJ8:BJ202)-ROW(BJ8),0)),(O8:O202="Yes")+0) Any help...