Before run code Check first if sheet name exist or not

**HaroonSid** · 05-22-2017, 05:29 AM

hi,
i am suing below to copy data and paste another workbook

Please Login or Register  to view this content.

before run this code i want to check that if a particular sheet exist on the workbook with name "Vouchers - Purchase Transactions With StockItems.XLSM

( workbook name should be = active workbook Sheets("entry").range("c5").value )

if sheet exist (sheet = Sheets("entry").range("c5").value) then first run another code if doesnt exist then run as its main fuction

thank you

**cytop** · 05-22-2017, 06:19 AM

Use your thread title as a Search term - a very common requirement with examples all over the place.

Before run code Check first if sheet name exist or not

LinkBack

Thread Tools

Rate This Thread

Display

Before run code Check first if sheet name exist or not

Re: Before run code Check first if sheet name exist or not

Thread Information

Users Browsing this Thread

Similar Threads

Check if sheet exist based on drop down list

[SOLVED] VB Code to check if same number exist

[SOLVED] Check First IF Sheet Is Exist With The Name Of Cell K7 If exist Then run the code

[SOLVED] check column headers against sheet names if sheet not exist create it

Code to check ComboBox.Value doesn't already exist in range before attempting to delete

Function to check the sheet name exist or not based on sheet values

macro to check if a value exist in sheet and add it if it doesnt

Bookmarks

Bookmarks

Posting Permissions