This group is a real treasure although I'm checking the group mails after a
long time.
Experts are contributing their knowledge and replying with valuable
solutions.
Congrats to them and keep the same spirit always!
mean while,
Dear Tushar,
Instead of using range I've used another simple method
ow we don't know."
____
From: tushar patki
To: excel-macros@googlegroups.com
Sent: Mon, 28 December, 2009 10:38:26 AM
Subject: Re: $$Excel-Macros$$ range method not working
Dear Praveen and Alokeshwar,
Thanks for the inputs. But actully I am trying to s
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
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, tu
know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: tushar patki
To: excel-macros@googlegroups.com
Sent: Sun, 27 December, 2009 11:39:33 AM
Subject: $$Excel-Macros$$ range method not
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 Sub
First line of procedure is not working giving error as 1004 - Select
method of range class failed. But When I merely try the code a
