Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

dynamic named range with offset()

0

Hi,

Can you please tell me how to add the formula (with offset function) to the "refer to" field of a named range, I am not able to copy the formula, just the cell itself.

Many thanks!

excel
MS Office Version: 2016
posted by: Owen (rep: 2) on Thu Oct 10, 2019 at 12:52 pm
Answer
Discuss

Answers

0

Copy the formula from the Formula Bar, above the spreadsheet's grid.

posted by: Variatus (rep: 4889) on Sat Oct 12, 2019 at 8:29 pm
Discuss

Discussion

It worked! many thanks!
Owen (rep: 2) Oct 15, '19 at 12:34 pm
Hi Owen, I'm glad my answer helped you. If you mark it as "Selected" it may help others, too, and increase my reputation. Thank you.
Variatus (rep: 4889) Oct 18, '19 at 5:09 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login