Hi guys,
I need a training/ tutors on advance excel (including sm basics), i will be
leaving for abroad in feb end. need to get ths learning before that. Anybody
pls suggest? if u r interested? or any other ways? pls help or call?
Thanks much
PrasannaKumar Bhavsar
9819002942
On Mon, 28 Dec 2009 12:43:14 +0530 wrote
>Hi Tushar,cells(i.3) in your code needs to be replaced by cells(i,3).I wrote
>the same code in the file attached and it executed to perfection.Please let me
>know if this is not what you are looking for.
Regards,PraveenOn Mon, Dec 28, 2009 at 10:38 AM, tushar patki wrote:
Dear Praveen and Alokeshwar,
Thanks for the inputs. But actully I am trying to select merged cells, which I
want to choose like - Range(Cells(2.3),cells(2,4)).Select as I would also like
to use for loop as -
For i = 2 to 4
Worksheets("A").Select
Range(Cells(i.3),cells(i,4)).Copy
Worksheets("B").Select
Range(Cells(i.3),cells(i,4)).Pastespecial
Next
I don't think If I use range method directly I wont be able to use For Loop.
But the above code is not working. can you suggest why?
Greatful to you for your valuable time devotion.
Tushar
On Sun, Dec 27, 2009 at 6:41 PM, kvc praveen kumar wrote:
Hi Tushar,If you do not want to select the sheet to implement your code try to
prefix the cells also with the worksheet reference like this:
Worksheets("sheet1").Cells(3, 25)This should fix the issue probably..Let me
know if this helps!!Regards,Praveen
On Sun, Dec 27, 2009 at 11:39 AM, tushar patki wrote:
Dear Experts
I am trying to get solution by this code
Private Sub CommandButton3_Click()
Worksheets("Ratios").Range(Cells(3, 25), Cells(3, 26)).Select
End SubFirst line of procedure is not working---- giving error as 1004 - Select
method of range class failed. But When I merely try the code as follows(without
giving the sheet reference): It works in the same sheet in which I have written
the code. I wonder how? Can anybody solve this:
Private Sub CommandButton3_Click()
' Worksheets("Ratios")
Range(Cells(3, 25), Cells(3, 26)).Select
End Sub
Please help.
Tushar
--
----------------------------------------------------------------------------------Some
important links for excel users:1. Follow us in TWITTER for tips tricks and
links : http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com3. Excel tutorials at
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com5. Excel Tips and Tricks
at http://exceldailytip.blogspot.com
To post to this group, send email to excel-mac...@googlegroups.comif you find
any spam message in the group, please send an email to:Ayush Jain @
jainayus...@gmail.com
HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and
links : http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com3. Excel tutorials at
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com5. Excel Tips and Tricks
at http://exceldailytip.blogspot.com
To post to this group, send email to excel-mac...@googlegroups.comif you find
any spam message in the group, please send an email to:Ayush Jain @
jainayus...@gmail.com
HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
HELP US GROW !!
We reach over 6,500 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 in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
>
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
>
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
>
If you find any spam message in the group, please send an email to:
>
Ayush Jain @ jainayus...@gmail.com
>
>
HELP US GROW !!
>
>
We reach over 6,500 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 in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 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
