| Home |
| Search |
| Today's Posts |
|
#24
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a "moving" range offset from Target
Howard Well not exactly! Your DD4 names are global instead of local. (I suspect you did not prefix with the sheetname where instructed) Have a look at my version in the NameManager window and note the 'Scope' for each name. Then fix your file so your names are as per the instructions... "..same as the other..." ..and then consider it a passing grade if it all works. Note that the names are all local scope except for the dynamic ranges and DD#_Lists. You can fix the RefersTo only in Excel. You can change the scope in the NameManager addin using multi-select, but to do this in Excel you have to delete the global names 1st, then recreate them as local. I reiterate that you start using the NameManager addin!!! -- Garry I'll work on that. H |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "ElseIf c.Value = "X_Clear" Then" and "...Target.Cells.Count 1"don't work | Excel Programming | |||
| Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
| Clear if "#N/A" and Find End of Range, Fill Blanks | Excel Programming | |||
| Moving between "row" and "range" formats in VBA | Excel Programming | |||
| SQL "INSERT INTO" Does not Modify Definition of Target Range | Excel Programming | |||
Threaded Mode
