Re: $$Excel-Macros$$ Range reference with Cells not working

See if this works: Dim WeekRangeSource As Range Set WeekRangeSource = Range(Cells(21, 10), Cells(350, 10)) MedianPerW = WorksheetFunction.Median(WeekRangeSource) AveragePerW = WorksheetFunction.Average(WeekRangeSource) StDevPerW = WorksheetFunction.StDev(WeekRangeSource) PS: I saw no use of the v

$$Excel-Macros$$ Range reference with Cells not working

Hi I am doing something wrong using the Range object. I can use the fixed "J21:J350" but does not manage the flexible Cell reference in this example. In this code the calculations work with: "J21:J350" but not with: Range(Cells(21, 10), Cells(350, 10)) Dim WeekRange As Range Dim WeekRa

$$Excel-Macros$$ Direct client requirement PENNDOT- SAR1- Data Architect (329796) Dauphin County PA

Hi, Hope you are doing Great This is sindhu from *AMENSYS INC*.We are immediately looking for *Data Architect *at *Dauphin County PA *with one Of Our Direct clients. If You Are interested Or know someone who is looking for projects, please reply me the details ASAP to *sin...@amensys.c

$$Excel-Macros$$ Hot Positions

Hello, Hope you are doing well please go though the below position's and let me know if you have any suitable consultant. Thank you. Alpharetta,GA Duration : 1 Year H1B / EAD / GC / USC Direct In-Person Interview Client looking someone who turned from Java to Hadoop Mid to senior level experie

Re: $$Excel-Macros$$ Access 2007 Tutorials

thanks for sharing!! On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR wrote: > Respected Mr Excel, > > You can check the following links. > http://allenbrowne.com/tips.html > http://www.baycongroup.com/access2007/ > http://www.gcflearnfree.org/access2007 > http://ms-access-tips.blogspot.in/p/advan

Re: $$Excel-Macros$$ Access 2007 Tutorials

Thanks for the reply..Mr.Vijay... On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR wrote: > Respected Mr Excel, > > You can check the following links. > http://allenbrowne.com/tips.html > http://www.baycongroup.com/access2007/ > http://www.gcflearnfree.org/access2007 > http://ms-access-tips.blogsp

Re: $$Excel-Macros$$ List in Userform

Hi, Can you please explain in steps how to do it. Thanks in advance. Regards, Chandra On Fri, Jun 7, 2013 at 7:05 PM, Bé Trần Văn wrote: > You use a label for each name. > > > 2013/6/7 Chandra Shekar > >> Hi, >> >> How to get List as attached in the userform >> >> >> Regards, >> >> Chandra >