+ Reply to Thread
Results 1 to 4 of 4

How to assign a Filtered Column of Dates Criteria Value to a Variable

  1. #1
    Registered User
    Join Date
    07-09-2021
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Microsoft 365
    Posts
    2

    How to assign a Filtered Column of Dates Criteria Value to a Variable

    I am having some trouble with this. I am trying to assign the value of the Criteria of a column of dates in a table to a variable. but keep getting an error.
    The recorded macro when I filter the table is:

    Please Login or Register  to view this content.
    when i try and assign the Criteria2 value to a variable i get this error:
    Run-time error '1004': Application-defined or object-defined error

    i could use some help please

    Code:

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    Re: How to assign a Filtered Column of Dates Criteria Value to a Variable

    Providing a sample file as stated in the yellow banner above will go a long way in getting some assistance and suggestions on a solution.

    In the sample file provide the before data and the after expected results.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  3. #3
    Registered User
    Join Date
    07-09-2021
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: How to assign a Filtered Column of Dates Criteria Value to a Variable

    unfortunately I cant attach the file

  4. #4
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    Re: How to assign a Filtered Column of Dates Criteria Value to a Variable

    Doesnt have to be the actual file, just a file with the same structure you currently have and fake test data to use to assist.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique numbers between dates with criteria on filtered sheet
    By L plates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2018, 07:50 AM
  2. [SOLVED] Copy the filtered dates, do Formatting and paste it back to filtered column
    By Rajkumar_h in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2017, 10:53 AM
  3. Replies: 2
    Last Post: 09-25-2013, 10:14 AM
  4. Select random text value from column and assign to variable
    By The Phil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2013, 02:09 PM
  5. [SOLVED] Need to assign week number to column of dates
    By Julieo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-29-2012, 11:46 AM
  6. Replies: 1
    Last Post: 07-25-2012, 11:05 PM
  7. Counting uniques dates in a filtered column
    By d_brian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2011, 01:35 PM

Tags for this Thread

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