98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Naming Cell Ranges
Naming Cell Ranges
Resolved · Medium Priority · Version 2007
Thu 5 Feb 2009, 16:58Delegate Oliver said...
Oliver has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Naming Cell Ranges
How is it possible to dynamically name a range of cells?
Fri 17 Apr 2009, 15:36Trainer Stephen said...
RE: Naming Cell Ranges
Hi Oliver
thank you for your question
First let me apologise for the delay in responding to your post
The following code programatically creates a name for a range of cells
Sub RangeName()
Dim rngRange As Range
Set rngRange = Range("a1:d42")
rngRange.Name = "Test"
End Subi hope this is useful
Regards
Stephen
Fri 24 Apr 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply currency format quickly in ExcelTo quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $ |
