+ Reply to Thread
Results 1 to 2 of 2

Referencing a Value

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2015
    Location
    Rochester NY
    MS-Off Ver
    2010
    Posts
    18

    Referencing a Value

    Would someone please tell me if I am referencing cell.Value here correctly? Or if there is a different way I am supposed to. Thanks, trying to debug.



                For Each cell In Worksheets("Change Master Task List").Range("M:M")
                    If c(i, j) = cell.Value Then

  2. #2
    Registered User
    Join Date
    09-21-2015
    Location
    Rochester NY
    MS-Off Ver
    2010
    Posts
    18

    Re: Referencing a Value

    I discovered the issue.

    c(i, j) resulted a "1" string while cell.value was 1 as an integer value. I converted c(i, j) with CInt(c(i, j))

+ 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. Converting VBA language referencing LotusNotes to language referencing Outlook
    By adubberkegreen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2015, 05:12 AM
  2. Replies: 0
    Last Post: 01-09-2013, 06:58 AM
  3. Referencing Every other row
    By jhashmore in forum Excel General
    Replies: 7
    Last Post: 04-14-2012, 07:44 PM
  4. Referencing
    By blinks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 08:56 PM
  5. Help with referencing.
    By Neil07979 in forum Excel General
    Replies: 2
    Last Post: 01-27-2010, 07:09 AM
  6. Help with 3-D referencing - I think
    By *kev* in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2008, 10:24 PM
  7. Lookup referencing cell referencing range
    By cmcconnehey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2008, 06:19 PM
  8. Help with referencing please
    By clueless_05 in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 09:44 AM

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