Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting and naming range
I have the following start to some code. I want to insert a copy of the
range baluster_blank above it and name it baluster1, unless that name is already being used, in which case baluster2, unless that is used and then baluster3, and so on. Sub insertbalusterrow() Dim rng As Range Set rng = Range("baluster_blank") rng.Copy rng.Insert 1, yes Where should i go from here? THanks. -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a quick way of inserting and naming multiple worksheets in Excel? | Excel Worksheet Functions | |||
naming a range | Excel Programming | |||
naming a range | Excel Programming | |||
VB Code Naming a Range (range changes each time) | Excel Programming | |||
Inserting Sheets and Naming | Excel Programming |