renaming

I really need help in creating a macros. I have a master workbook<--huge file. Project 1 workbook is where the user may pick selection using check box application. Depending on what selection the user chooses in Project 1 workbook, it grabs all picturelookups, formulas, calculations from the...

Hi all, I have a workbook template with a couple dozen named ranges. Since it is a template, I am naming all of the ranges with an XX at the start, i.e. XXmonths or XXcreditdue. When I use the template to load data for a client, I want to change the XX's to the acronym of the client I am...

Hello, hoping someone here can help me. I have 2500 product images in folder that need to be renamed. I've been giving an Excel spreadsheet that looks like this: Column A - current file name. Column B - new file name. I need a script that will us Column A to find the approrpiate image in...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

This might be elementary, but I cannot get it to work. I need to name range in VBA, work with the named ranges afterwards and change the names. I have split it into e couple of questions below. 1. Naming a range By using 'Worksheets("Ark1").Range("C4").Name =...

Hello! Heres one for you guys. Is it possible to rename the 2 tabs in my spreadsheets to 1 and 2 with a macro no matter what name they currently have? Many thanks Lex