Results 1 to 10 of 10

How to write reference to Table in vba

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Wilmingotn DE USA
    MS-Off Ver
    Excel 2016
    Posts
    67

    Question How to write reference to Table in vba

    Dear Sirs
    I have a problem to write reference to Table.
    Normally with a range I would write looping "For Next" like that:
     
    For i=1 to range("rgsample").rows.count  
    ...
    next i
    how to write it if I need to check rows in Table1
    I tried things like: for i=1 to Table1.rows.count and many similar comibnations and nothing works.
    I means for me I need to get educated in this field. Please help

    MODERATOR COMMENT: Code Tags added. Please use them in the future.
    Last edited by alansidman; 06-25-2020 at 11:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to write VBA code to clear a table but preserve table and 1 empty row
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-28-2019, 07:26 PM
  2. Write back to table source from a resorted table on another worksheet
    By fuadramsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2018, 07:42 PM
  3. how to write text with reference fields
    By livelymind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2013, 07:00 AM
  4. How to write in Word w/o Reference
    By Gérard Ducouret in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2006, 10:10 AM
  5. [SOLVED] How to write in Word w/o Reference
    By Gérard Ducouret in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2006, 07:15 AM
  6. How do I write macros with relative reference cells
    By trilogylynch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2005, 05:05 PM
  7. [SOLVED] Looking for documentation/reference to write Excel Macro
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2005, 02:06 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