named range macro

Hi, I copied a tab with a million named ranges and formulas. I’d like to rename all on the new name to be prefixed with a tab indicator while leaving the original named ranges unchanged. Currently the name manager has duplicate entries for each name, distinguished only by address. I found...

I have a database that will be constantly changing in length and for purposes of conditional data validation, I want to name hundreds, potentially thousands of ranges. I have made it far enough to get a table on a separate sheet with what I want the name of each range to be in column A and the...

Hi, I want to create named range from selection (left column). Can any one help me with how to write a macros for it. Thanks in advance

I have a named range in my workbook that is a constant value (Cratio=2.3755799). I want to refer to this value in my macro in a formula and then copy the answer of that formula back into the workbook. There are two ways that I have referred to this value and both are causing a 1004 error. They...

Hi there, I'm going to start off by saying that I am pretty new to excel in general and wholly inexperienced with VBA. That being said, I was wondering if there was a macro that could look at a row and take the values of two cells, combine them and then create a range name for a third cell in...

Hey Everyone, I have a worksheet that is tracking payroll by department by bi-weekly payroll period. In one column (Column C for example) is the current payroll period payroll figure and in column G, as a comparison, is the prior year's figure for the equivalent period. There are 26...

Hi Smart Peeplz! I'm having problems with a bit of code I'm trying to use and I'm hoping someone out there can help. I need the macro to create a named range based on a last column and row that can change. It won't change once the report is set up, but since this is a template that will be...