On Wed, Mar 18, 2015 at 5:31 PM, saravanan R wrote:
> Hi Mandeep,
>
> Thanks a Million.
>
> I have one more query related to the same file, is it possible to split
> the file based on "Status" OK wrt to each Coleague.
> and file name should be QueryDup-FK & QueryDup-BD (colleague name will be
> d
The below code already given in this group by Mr Asish Kumar
start= ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeVisible).Row
end= ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
norows=end-start+1
Regards
Eugene
On Thu, Mar 19, 2015 at 12:56 PM, Mandeep baluja
wrote:
Hi,
Hope you are doing great...
Please let me know your interest along with your updated resume
(If you are not available please refer this Position)
[Please send resumes to r...@technotalent.com]
*Position*
*Title: Sr.Java/J2ee Lead/Architect*
*Location: Sanjose, CA*
*Duration: 6
Hey Eugene,,not easy as you're thinking
This code will not give the correct result end -start +1 will never be
equal to no of hide rows with filter, because these variable dont know the
actual no of hidden rows between the data.
for example see data if i hide 2 and 4, first visible row will