Hello,
How to get count of visible cells in Pivot tables where as below line gives
us entire count of pivot field Name.
Thanks in advance.
pitmcnt_nm = pvt_tbl.PivotFields(nm).PivotItems.Count
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Dear Chandrashekar,
Pl share the sample data.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Nov 15, 2013 at 2:13 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
How to get count of visible cells in
Plz send the process as iam new to QC
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
Sheets(New).Select
On Error Resume Next
For i = 2 To ActiveSheet.UsedRange.Rows.Count
If Cells(i, 14) 25 Then
Cells(i, 16) = 2
Endif
If cells(I,14)25 then
Cells(i,16)=5
Endif
next
From: excel-macros@googlegroups.com
Sub DeliveryCost()
Dim i As Integer
Dim j As Integer
Dim iEndrow As Long
iEndrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To iEndrow
If Cells(i, 14).Value 25 Then
Cells(i, 16).Value = 2
Else
Cells(i, 16).Value = 5
End If
Next
End Sub
On Fri, Nov
Dear Coders,
iam new to VBA, was trying to automate my work, this is the last step of my
task, some images are stored at a path ( here the path is in sImgPath )
when i try to insert the image in the email, first image is inserted
properly, but when there is the second iteration, it deletes the
*PLEASE HELP!!!*
-- Forwarded message --
From: Abhishek Jain abhishek@gmail.com
Date: Wed, Nov 13, 2013 at 10:16 AM
Subject: $$Excel-Macros$$ Formula to fetch employee names based on time
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Friends,
I have a file,