Results 1 to 8 of 8

Check if Column Exist

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Houston
    Posts
    17

    Check if Column Exist

    Hi, I have question...I have been search around but I couldn't find anything that would fit my needs.

    How I can check that certain column exist and each column is right sequence.

    I have put together macro that runs on my reports, reports coming from multiple source, right now macro run fine but I would like to create some type of validation to check if columns exist or have extra column and they are in right place otherwise my macro might blowout. My micro is not dynamic to recognize specific column by name. So if i have this validation it would warning me about changes in report design so I can alter my macro or just move extra column to the lust column where I don't have any calculation before I run my macro.

    Is this possible to make:

    - Check for column heading if it exist in range from A1:O1 or Array of column names
    if exist = do nothing
    Else = let me know, some type output message to a user and stop macro
    - Check if column is in right sequence
    if in right sequence = do nothing
    Else = let me know, some type output message to a user and stop macro
    - Check what's is new, what column is added
    if new column is added between any of column in range then = move to the first empty/available column
    Else = do nothing

    Rest of macro will executed from here

    If somebody has any ideas on how to do this it would be of great help to me. I'm have attached sheet with column heading only.

    Thanks a lot for any help on this issue.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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