Sent via BlackBerry by AT&T -----Original Message----- From: excel-macros+nore...@googlegroups.com Sender: excel-macros@googlegroups.com Date: Sun, 22 Aug 2010 23:39:03 To: Digest Recipients<excel-macros+dig...@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 8 Messages in 6 Topics
============================================================================= Today's Topic Summary ============================================================================= Group: excel-macros@googlegroups.com Url: http://groups.google.com/group/excel-macros/topics - paths between cells [1 Update] http://groups.google.com/group/excel-macros/t/433b8f3fdcbe9b46 - what is coding of previous and next button in excel [1 Update] http://groups.google.com/group/excel-macros/t/f7999c9df1fadf53 - Need Help in Cross tab [2 Updates] http://groups.google.com/group/excel-macros/t/c595c4f3ae07243c - converting 2003 to 2010xl [1 Update] http://groups.google.com/group/excel-macros/t/f4bd67525121a4b1 - Moving from 2003 to 2010 xl [1 Update] http://groups.google.com/group/excel-macros/t/363ae54e85decf5 - Ageing of data [2 Updates] http://groups.google.com/group/excel-macros/t/5eb3701b28d42bf3 ============================================================================= Topic: paths between cells Url: http://groups.google.com/group/excel-macros/t/433b8f3fdcbe9b46 ============================================================================= ---------- 1 of 1 ---------- From: n3wsgr0ups <stozs...@gmail.com> Date: Aug 22 07:32AM -0700 Url: http://groups.google.com/group/excel-macros/msg/7c77ab9f0c3d6939 Need you brains guys! Suppose I have a defined range on my worksheet, and within that range I have numbers or blank cells. i'm trying to write some vba code that given 2 cells as a start and stop point, finds all the blank cell "paths" between those two numbers. ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need to produce a list of non blank cell paths between the 1 and 5. a path being a way to traverse the cells between the two numbers by "walking" on non-blank cells including cells that touch at corners. Thanks in anticipation. ============================================================================= Topic: what is coding of previous and next button in excel Url: http://groups.google.com/group/excel-macros/t/f7999c9df1fadf53 ============================================================================= ---------- 1 of 1 ---------- From: neil johnson <neil.jh...@googlemail.com> Date: Aug 22 02:25PM +0530 Url: http://groups.google.com/group/excel-macros/msg/aa01e6965ecef686 Hi Everyone, I make user form in excel. But I don't know how to run *"Previous button and next Button" in *excel by making vba code. Please help . What is Syntax of this button ? I know only Syntax = dim lastrow lastrow = range("A65550").end(xlup).row+1 range("A" &lastrow).value = textbox1.text range("B" & lastrow).value = textbox2.text Thanks ============================================================================= Topic: Need Help in Cross tab Url: http://groups.google.com/group/excel-macros/t/c595c4f3ae07243c ============================================================================= ---------- 1 of 2 ---------- From: Dave Bonallack <davebonall...@hotmail.com> Date: Aug 22 03:10PM +0800 Url: http://groups.google.com/group/excel-macros/msg/2fb14d7887ea9ebd Hi, I have re-done your sheet using VBA. It will accommodate as many rows as needed on the report sheet, and up to 10,000 rows on the DATA sheet (although this can easily be increased) The button can be moved to any convenient spot on the worksheet. Just right-click, then drag it. Regards - Dave. To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: shariqcoo...@gmail.com Date: Sat, 21 Aug 2010 10:19:33 +0000 Yes Dave......the solution is very good......but I want to do this by clicking the bottom and the data could me any length n the only constant thing is the hours which is not more then 22 but can be less Sent on my BlackBerry® from Vodafone From: Dave Bonallack <davebonall...@hotmail.com> Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 18:16:12 +0800 To: excel-macros@googlegroups.com<excel-macros@googlegroups.com> ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: aind...@gmail.com To: excel-macros@googlegroups.com Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack <davebonall...@hotmail.com> wrote: Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantly with any change to the DATA sheet; and some people don't like opening or receiving files with macros. Regards - Dave. > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe ---------- 2 of 2 ---------- From: shariqcoo...@gmail.com Date: Aug 22 07:15AM Url: http://groups.google.com/group/excel-macros/msg/afcc9cca5e6feeb6 Thanks Dave Thanks for your help.....I have not checked the sheet coz I'm not on my laptop but I know your are very good in vba. Thanks Shariq Sent on my BlackBerry® from Vodafone -----Original Message----- From: Dave Bonallack <davebonall...@hotmail.com> Sender: excel-macros@googlegroups.com Date: Sun, 22 Aug 2010 15:10:50 To: excel-macros@googlegroups.com<excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Hi, I have re-done your sheet using VBA. It will accommodate as many rows as needed on the report sheet, and up to 10,000 rows on the DATA sheet (although this can easily be increased) The button can be moved to any convenient spot on the worksheet. Just right-click, then drag it. Regards - Dave. To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: shariqcoo...@gmail.com Date: Sat, 21 Aug 2010 10:19:33 +0000 Yes Dave......the solution is very good......but I want to do this by clicking the bottom and the data could me any length n the only constant thing is the hours which is not more then 22 but can be less Sent on my BlackBerry® from Vodafone From: Dave Bonallack <davebonall...@hotmail.com> Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 18:16:12 +0800 To: excel-macros@googlegroups.com<excel-macros@googlegroups.com> ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: aind...@gmail.com To: excel-macros@googlegroups.com Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack <davebonall...@hotmail.com> wrote: Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantly with any change to the DATA sheet; and some people don't like opening or receiving files with macros. Regards - Dave. > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe ============================================================================= Topic: converting 2003 to 2010xl Url: http://groups.google.com/group/excel-macros/t/f4bd67525121a4b1 ============================================================================= ---------- 1 of 1 ---------- From: Martin Wheeler <madwhee...@gmail.com> Date: Aug 22 04:32PM +1200 Url: http://groups.google.com/group/excel-macros/msg/c51e932c00f6bf17 I am trying to go from xl2003 to xl2010 and keeping running into problems with functions. Such as TimeSerial(Hour(Time), Minute(Time) ). Does anyone know of a list of conversions? Any help would be greatly appriciated. Ta, Martin ============================================================================= Topic: Moving from 2003 to 2010 xl Url: http://groups.google.com/group/excel-macros/t/363ae54e85decf5 ============================================================================= ---------- 1 of 1 ---------- From: Martin Wheeler <madwhee...@gmail.com> Date: Aug 22 04:30PM +1200 Url: http://groups.google.com/group/excel-macros/msg/25d1bff3b152a919 I am trying to go from xl2003 to xl2010 and keeping running into problems with functions. Such as TimeSerial(Hour(Time), Minute(Time) ). Does anyone know of a list of conversions? Any help would be greatly appriciated. Ta, Martin ============================================================================= Topic: Ageing of data Url: http://groups.google.com/group/excel-macros/t/5eb3701b28d42bf3 ============================================================================= ---------- 1 of 2 ---------- From: Antony <tonycrazy...@gmail.com> Date: Aug 21 03:22PM -0700 Url: http://groups.google.com/group/excel-macros/msg/7b791e66d93e21a8 Hi Dave, Thanks a lot for the quick response. Its working perfectly.....Thanks once again. Regards, Tony ---------- 2 of 2 ---------- From: Dave Bonallack <davebonall...@hotmail.com> Date: Aug 22 02:09PM +0800 Url: http://groups.google.com/group/excel-macros/msg/fe11fe9044629609 You're welcome. Regards - Dave. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe