Home |
Search |
Today's Posts |
#17
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
May be back with a couple more what-if's, the code looks pretty
intense! But at least I know what it is supposed to do, which will be helpful. I was already thinking how to handle if the lists get edited after they're stored in the array. If shortened the resize to ClearContents will leave populated cells. My thought is to store a delimited list... name:rows ...and use that instead of current size! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |