exist

  1. ibmy

    Check if Number Exist in Row Range

    Hi, Sample of 100+k rows data: DEFGHIJKLM1MaxBIBexpected result :231.207021.207024Max Exist41.207021.2067551.207021.2088961.207021.2030271.207021.2070281.207031.207031Max X91.207031.20701101.207061.207063Max X111.207061.20702121.207061.20705131.207061.20702141.207021.20699151.207241.207246Max...
  2. N

    VBA code to find a cell matching two criteria

    Hi, I have a code that works fine with all conditions accept the one and need your help please My code says: Check if the name is exist or not If not, then GoTo new_item (it works great) If exist and the BarCode is exist for the same name then just add the quantity (This is what I need) If...
  3. V

    Detect if worksheet exist, and if it does ignore the rest of the script

    I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script. I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble... Of course this might not be the ideal way to...
  4. N

    Check Value if exist in a range and then....

    Hello, I have the following code to add the input BarCode and it's related details to the next available raw in sheet2 column ("P") Here is a piece of my code that works fine: [CODE]Dim ws As WorksheetSet ws = Sheet2 nr = ws.Cells(Rows.Count, "P").End(xlUp).Row + 1 ws.Cells(nr, "P") =...
  5. J

    Sorry, We couldn't find...

    Hi, When I load my Excel file I keep getting the following error message: "Sorry, We could not find 'Path/Week_xx.xlsm'. Is it possible it was moved, renamed or deleted?" When I click OK, I then get: "Microsoft Excel can not access the file 'Path/Week_xx.xlsm'. There are several possible...
  6. J

    Erasing Arrays after use question

    Hi, I have a macro that uses multiple arrays and after use I have a reset button which clears these: erase MyArray1 etc... However in some cases not all arrays are initiated so when I attempt to erase those I get an error as they don't exist. Is there a way, when erasing them to check if they...
  7. mayday1

    IFERROR or ISERROR or something if no file or no tab

    I have a report with links to files that might not exist and to tabs that might not exist (but are in files that do exist). I'd like my report to be the same every month requardless so the same file works every month whether or not certain files or tabs are missing. How can I do something...
  8. X

    VBA for searching a folder and deleting files based on a pre-determined list of file names

    Hi all, I would very much appreciate your help with the following: Description of problem: I have 1 tab in my Workbook ('File Names List') which has a list file names and the corresponding path listed. File Names are listed in Col. A starting row 3 and File Path are listed in Col,B also...
  9. A

    Countif Statement Showing Incorrect Value

    With ws_data .Range("J:J").Clear For t = 2 To nwb_LastRow rn_1 = .Cells(t, 3) temp_fac = .Range("H" & t) & .Range("I" & t) If Application.WorksheetFunction.CountIf(ws_rd.Range("A:A"), rn_1) = 0 Then...
  10. CPGDeveloper

    Import Specification -- Cannot Find??? I'm sure it's there!

    I'm trying to execute this line of code: DoCmd.TransferText acLinkDelim, "TheUploadSpec2", "ltUpload", upPath & upFileNm, True I keep getting Error '3625' -- Specification Does Not Exist. But I swear it absolutely does! When I go to External Data>New Data Source>From File>Text File...I click...
  11. W

    Check if file exists. Keeps skipping the existing file.

    Hi. So, i got a code for checking if a file exists from google. The problem is with it, even tho the file actually exists, it keep skipping it, as it didn't exists. Code: Sub CFF() Dim fso: Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists("Desktop\SkjKa.xlsm") Then...
  12. G

    Search a multiple value cell against an array

    I'm trying to find out how to use a formula to search cells containing multiple values against an array of values and either extract those values to another column or just return some identifier (not exist v exist, etc.). Is this possible? ex: target cell values are in this format 860032011...
  13. A

    Conditional Formatting Question

    Hello I am hoping that you are able to help please I have a worksheet which receives a feed into "Sheet 1". If an item in column "F" of sheet1 does not exist in column "H" of sheet 2 then our team need to add it on to Sheet 2. They then set column "R" of sheet 2 with how many instances there...
  14. V

    Indirect with variable

    I am using the formula below and it works great. SUMPRODUCT(SUMIF(INDIRECT("'"&REF!$C$2:$C$26&"'!$B$10:$V$10"),K$1,INDIRECT("'"&REF!$C$2:$C$26&"'!$B$17:$V$17"))) My only challenge is that some of the tabs in the range $C$2:$C$26 don't exist yet. So to get around this I have just adjusted the...
  15. T

    Can I create a sort of "Anti Tamper" macro?

    Hi Everyone, I have a document thats going to go out to over 200 people. I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as...
  16. A

    vb code to send PDF in workbook path / folder

    Dear Sir I am using following code and it copying my file It is copying my file to current folder where original file exist, I just need on amendment to send this file to a folder name PDF, if folder not exist then VB need to create it Thisworkbook.path/PDF
  17. S

    Setting a Range using a cell

    Im having trouble finding the syntax to correctly define a range variable. I am receiving an error on the lower of the two lines. These lines both exist within a with statement. If .Cells(bb, "A").value = sampleVar Then Set TblRng = .Range(Cells(bb, "A"), Cells(bb...
  18. M

    VBA copy row to new sheet if cell value isn't found in range

    Hello I'm trying to write a macro that will copy an entire row from sheet2 and paste it to the bottom of sheet1 if the cell value in column f sheet 2 doesn't exist at all in column f on sheet 1. For example if column f sheet 2 = 123456 and 123456 doesn't exist anywhere in sheet1 column f then...
  19. J

    how to check if a sheet exist?

    hi, i know how to: Dim WorksheetExists As Boolean WorksheetExists = Evaluate("ISREF('Graficas'!A1)") and work But i am work with some workbooks.... and then i need evaluate if exist sheets on each workbook. this: WorksheetExists = Evaluate("ISREF('Graficas'!A1)") Evaluate in the last opened...
  20. J

    More Graph/Charts Types

    Hi all. Exist more type of Graphs/Charts? more moderns? Thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top