By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,101 Members | 1,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,101 IT Pros & Developers. It's quick & easy.

countif and loops

P: 13
Hi,

Question 1:
How do I count all cells with value >0 in a floating column? MY range is

Range("C1:C" + CStr(FLOAT)).Select

I'm trying to count all cells with values >0 in this above range.


Quetion 2:
I'm also trying to loop the following to include multiple columns from column C to column M in sheet3.

When looping, I also need to keep the reference to column A and B static but everything from C onwards to loop thro to column M.

Worksheets("Sheet3").Select
For x = 2 To eSelection
sCellID = "C" + CStr(x)
If Range(sCellID) > 0 Then
sAmt = Range(sCellID)
sCellID = "B" + CStr(x) 'Exp Accts
sExpAcct = Range(sCellID)
sCellID = "C1" 'Name of Vendor
sVendorID = Range(sCellID)
sCellID = "A" + CStr(x) 'Name of Exp Acct
sExpName = Range(sCellID)



FillPurchase
End If

Next


Thank you so much...any help is appreciated.

Suki
Mar 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.