$$Excel-Macros$$ Re: week update

-- Hi, Here is the solution to your query: http://www.excelitems.com/2009/02/show-first-day-of-current-week.html Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Ce

$$Excel-Macros$$ Creating balance sheet from Trial balance

Hi All, I need to create balance sheet from trial balance. Though I know the logic of doing it, I am dazed by the task of doing it thru a macro.. I ran a thorough search but could not get hold of relevant stuff. Anyone has any idea or any code which would help?? If yes, please let me know..It wo

$$Excel-Macros$$ Re: plz i need ur help! (urgent)

thanks a lot Harmeet Singh ;) it works perfectly ! On Feb 21, 4:23 pm, Harmeet Singh wrote: > try this > > Sub ggg() > > Dim MyColumn As String > Dim MyRange As Range, MyRange1 As Range > MyColumn = "A" > myvalue = "Main" > lastrow = Cells(Rows.Count, MyColumn).End(xlUp).Row > Set MyRange = Ran

$$Excel-Macros$$ Re: Urgent Help need to count values

Hi Kori, It happens sometimes just close the file and open it again. If it works then good else place the macro in a module, rather than putting it in elsewhere. Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Office Specialist Technical Trainer - Excel and VBA 0-