Results 1 to 6 of 6

defining an array and deleting values

Threaded View

Tortus defining an array and... 08-15-2016, 01:07 PM
JieJenn Re: defining an array and... 08-15-2016, 01:11 PM
Tortus Re: defining an array and... 08-15-2016, 01:56 PM
Tortus Re: defining an array and... 08-15-2016, 01:37 PM
JieJenn Re: defining an array and... 08-15-2016, 01:39 PM
nilem Re: defining an array and... 08-15-2016, 01:57 PM
  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Thumbs up defining an array and deleting values

    Hello. I may be way off track here but would like some help. I'm not sure how to make the array part of what I'm trying to delete.
    Sub Head_Clean1()
    Dim h As Range
    Dim var As Variant
    var = Array("_Properties", "subassembly", "_DCSVariable", "_HistVariable", "_EHASVariable", "_ManualVariable", "_TemplateVariable", _
    "_DCS", "_Hist", "_EHAS", "_Manual", "_AES", "_OtherParameter", "_AlarmRelatedParameter", "_Constraint")
    
      For Each h In ActiveSheet.Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row)
      If h.Value Like "'_*" And h.Offset(0, 2).Value = var Then h.EntireRow.delete
    
    Next h
    
    End Sub
    Last edited by Tortus; 08-15-2016 at 01:57 PM.
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Defining Array Criteria
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2014, 06:44 PM
  2. [SOLVED] Defining Variable 2D array?
    By magicbob007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2012, 08:19 PM
  3. Pre defining a two dimensional array
    By first_earth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2010, 07:53 AM
  4. Defining the array within VBA code
    By sh3896 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2008, 01:25 PM
  5. Deleting Last values in an array
    By gti_jobert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2006, 06:49 AM
  6. [SOLVED] Deleting blank values from an array
    By chemdude77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2006, 03:35 PM
  7. Deleting blank values from an array
    By Rich J in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1