Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default deleting array element

I am kind of new to the programming world and am trying to
create a loop that will check certain fields of a user
defined data type and delete it if it meets certain
criteria. My user-defined data type looks like this;

Type SwitchingTimes
DayofWeek As String * 3
TimeSwitch As Date
Phase As String * 1
SwitchON As String * 3
feeder As Long
kVARs As Long
End Type
Dim Switching() As SwitchingTimes

I would like to delete all elements at a time... for
example if at i=3 the criteria are met, I would like to
delete Switching(3).DayofWeek, Switching(3).TimeSwitch,
Switching(3).Phase, etc for all. I tried the code Set
Switching(i)= nothing but that gives an error... thanks
in advance for the help
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Array element asingh Excel Worksheet Functions 4 April 12th 10 03:30 PM
Can one store a string in a Array element? [email protected] Excel Discussion (Misc queries) 1 April 17th 07 12:53 PM
Search array and return element No Ron Excel Worksheet Functions 7 May 17th 06 05:27 AM
array functions and complex element values frustrated Excel Worksheet Functions 0 March 14th 06 12:44 AM
Permutations of an array element < to a value Bruce Excel Worksheet Functions 3 January 31st 06 05:00 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"