exist

I have the following macro below. Where file does not exist, the data to be cleared in active sheet from A19:AA100 Sub DataRefresh() Application.DisplayAlerts = False Range("E14").Select Selection.QueryTable.Refresh BackgroundQuery:=True Range("G19").Select...

In Excel VBA, I can run this code: if evaluate("ISREF('Sheet1'!A1)") then I now want to expand on that to refer to a sheet on another open workbook. I found this syntax online: if evaluate("ISREF('[MyFile.xlsm]Sheet1'!A1)") then If Sheet1 exists, it returns true. If Sheet1 does not exist...

Hello all. I am looking for a 3 in one here. I have a macro that will save a file automatically when ran. However, I am looking to use a new macro for a workbook. I do not have any code right now, as everything I found has not worked. What I want to do is check if a folder/subfolder...

Hi, I used mod function to get remainder for 246. =IF($M2<>0,IF($M2>60,$M2+IF(MOD($M2-60,6)>0,6,0),60),0) I used above formula in column N. Column M has formula too. If M2 has bigger than 60, then minus 60, and then divide by 6. IF remainder exist, then add 6, or add 0. M2 was 246, and N2...

I am trying to write a for loop that will try to find each value in sheet 1 column A in sheet 2 column A. If the value in sheet 1 column A exists anywhere in sheet 2 column A then do nothing. If the value doesn't exist in sheet 2 column A then set sheet 1 column D to "Does not exist". This...

I'm trying to understand an excel sheet that I inherited. Some of the formulas reference a worksheet that simply doesn't exist in the workbook. I've tried every way I can think of to unhide sheets and the options are always grayed out, in my mind meaning they don't exist. I tried using the...

I've been trying to prevent user entry error for column entry. The following works for every column but "C" and column "C" does exist. I don't get it. Thanks for any assistance. Dave Sub RealColumn() Dim Outputcolstr As String, Lbstr As Variant, Cnt As Integer, Cfind As Range Outputcolstr =...

Hello, the current code below copies files from the source folder to the destination folder based on cell value and file extension. The files may or may not be used all the time, if the file is not in the source folder I am getting an error. I would like to add code that will skip to the next...

I have an Excel 2016 PowerPivot data model where I'm trying to find a member value based on whether 4 other member values exist. A sort if "if" statement. If Values A, B, C & D exist, bring me back value E. Value E can be 1 of three things based on values A-D being found. I've researched...

I am looping through a collection and try to trap the error that occurs when the member of the collection does not exist. I can't get my error handling to deal with the situation, it just ignores my direction to go to a line number and crashes. On Error GoTo 32 If Not...

I am new to Excel VBA, i am currently making a data entry function and i hope my program has the function that allows program autofill the rest textboxes and check boxes when the users input both "institution name" and "investor name " match the information in the excel worksheet, so the users...

Hello All, I am searching for a value with a vlookup that can range from 0-999. Occasionally the value will not exist so I am returning a value of 1. =IFERROR(VLOOKUP("*"&M12&"*",EPN!$Y$14:$Z$40,2,FALSE),1) The cells I am referencing are as below for the 2 fields. However I am getting false...

Hi need a macro which would browse to a location (local drive) and load multiple sheets on a workbook based on a user selection (single or multiple sheets) of extension (.xlsx only) and rename them in serial order with prefix "D-" Example : D-1, D-2, D-3 and so on If there already exist...

I have a report that i want to run based on a files existence in a folder on my desk top. My desired result: Click on the "ActiveX Box", Macro would run to determine if file "Dealer Inventory" exist. If, it exist Then, run Private Sub RunPLTS() Else, run Private Sub RunNOPLTS() End...

Hello All Sheets("Template").Select Range("A9").Select If Selection <> contents Then Exit Sub End If I'm trying to not run the sub, if Range A9 in the Template worksheet is blank (no data exist). If A9 has nothing in it, the Template work sheet simply remains the same...

Hi Everone, I need to compare two sets of rows in same sheet and highlight rows where duplicates exist. I know about conditional formatting highlight duplicates but thats not giving me the desired output as I have duplicates in each set of row as well. I need formula/macro to ignore the...

Hello friends, Hope all is well! please help me add an Exclamation/question mark (image) to the below msgbox. MsgBox "The Cost Details" & vbCrLf & "And/Or" & vbCrLf & "The Revenues Details" _ & vbCrLf & "Don't Exist", , "The entered Dr. ID is NOT showing" Thanks a lot in advance!

This function returns a true or false statement if the corresponding lookup value is less that the table settings. The lookup-table is static but the lookup-values are dynamic and may exist in the lookup-table in more than way. We have built the function logic to answer the question 'does this...

Hello everyone, I am new with all macros and I`m trying to create macro which saves copy of workbook. But I cannot get my head going how to create one bit.. how to check the location before saving and if file name already exist message will come "file already exist please check name field" and...

Hello i am trying to do call a macro if an error occours. Basically, the error is literally when the text file does not exist on a querytable, so when the .txt file does not exist i get an error, so i tried the below, but it does not bypass the error. it still displays the error message thet...