Posts by kingtimthei

    Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Hmmm, I'm not sure.
    Try adding "NumSheets" to the Dim Statement since I hadn't defined it in my original example

    Code
    Dim r, NumSheets As Integer


    It worked for me without it, but sometimes it is not so forgiving.
    If it is still giving you problems it may be the version of Office you have. I am using MS Office 2010.

    Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Slightly different take on it cshortt,
    I usually use Cells(row #, col #) to reference my data.


    Try the following: