Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 16 Messages in 7 Topics

2010-07-02 Thread tushar patki
Hi Magandeep, I am also a CA practicing in Pune..I am not an expert, but sometimes do coding for enjoyment. I have a lot of such small assignments, for my daily requirements. If you are interested, I can share you some tips.. Before that let me know what do you do and some words about yourself. O

Re: $$Excel-Macros$$ range method not working

2009-12-27 Thread tushar patki
. > > 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() >> >> Worksh

$$Excel-Macros$$ range method not working

2009-12-27 Thread tushar patki
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

$$Excel-Macros$$ Re: Cap Gains calculation on shares, on FIFO basis

2009-10-11 Thread tushar patki
Hi Prabhakar, The transactions pertaining to capital gains are not so straight forward, say for eg whether the STT is paid on the same or what about the exemptions available etc. There may be many other angles attached to such transactions. Hence what I propose you that excel will never be suffic

$$Excel-Macros$$ To make the color of the cell white

2009-07-06 Thread tushar patki
Dear All, I have written a code which will copy cell contents from one cell to another. Along with the cell contents, also formatting of the cell is copied. I am not able to code and keep the formatting as I want. For eg. Cell A1 has color yellow. I copied cell A1 to B1. The color also gets copi