Re: $$Excel-Macros$$ Need a Macro

I will give this a shot. Thank you so much. Sent from my iPhone On Mar 10, 2011, at 9:20 PM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, One approach is to insert a new blank sheet, call it END and move it to become the last sheet in the workbook. Whenever adding new sheets, make

$$Excel-Macros$$ Solustion for Num2text formula

Dear all Please help me in attach file the problam are mention in attach file and require the help for it. Require help immediate. Thanks Regards Manhar Prajapati -- -- Some important links for excel users: 1.

Re: $$Excel-Macros$$ Formula Query

Dear Vikram Please use attach addins file. Regards Manhar Prajapati On Fri, Mar 11, 2011 at 11:53 AM, vikram vikramahuj...@gmail.com wrote: Hi, Please help if anybody can provide formula regarding below query: Whenever we type any amount i.e. in number such as Rs.1000.00 it converts

Re: $$Excel-Macros$$ Solustion for Num2text formula

Dear Manhar, Please see attachment... On Fri, Mar 11, 2011 at 12:59 PM, manhar prajapati prajapati.man...@gmail.com wrote: Dear all Please help me in attach file the problam are mention in attach file and require the help for it. Require help immediate. Thanks Regards Manhar

$$Excel-Macros$$ Name AND CODE

Hi Experts Please find the attached file in the attaché file I have some Code and Name which are in one column. I want bifurcate this with two column one is Name one is Code. Please confirm, if any specify formula for this . Regards Kailash --

Re: $$Excel-Macros$$ Playing Gif files in excel

Hi Sanjoy, Thanks for your early reply. Can you tell me how can I add the Gif file in Html and insert the same into the sheet. Regards Santosh On Fri, Mar 11, 2011 at 11:48 AM, Sanjoy Nath sanjoy.nath...@gmail.comwrote: add the gif file in html and insert that html file to the sheet On

FW: $$Excel-Macros$$ Import .csv match records

Hi, Please add my email id to the group. Thanks! Regards, Kirpal From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dave Bonallack Sent: Friday, February 18, 2011 7:51 AM To:

Re: $$Excel-Macros$$ Solustion for Num2text formula

Hi Thanks you for reply. But i Require the last amount is calcualte in 2 desibal it means if the number is 100.5201 its calcualate only 100.52 so when i round of the amount as +.48 its comes 101. For more details please look Attach file Regards Manhar. On Fri, Mar 11, 2011 at 5:00 PM,

RE: $$Excel-Macros$$ Formula Query

Hi Manhar, Thanks for your help. I wanted a written formula or such rather than .xls file. Secondly,if there is no such formula then how I can use this .xls file for converting all numbers in text as mentioned below such as converting below sample data. 1000 2000 3000 4000 5000

Re: $$Excel-Macros$$ Solustion for Num2text formula

try this =ROUND(SUM(E23:E33),0.00) On Fri, Mar 11, 2011 at 6:30 PM, manhar prajapati prajapati.man...@gmail.com wrote: Hi Thanks you for reply. But i Require the last amount is calcualte in 2 desibal it means if the number is 100.5201 its calcualate only 100.52 so when i round of the

Re: $$Excel-Macros$$ Solustion for Num2text formula

Just so you know... desibal? If that was decibel, it would be a unit of sound. (a ratio, actually) Decimal is the number of digits after the dot in a number. Secondly.. the answer below: =round(sum(e23:e33),0.00) will not work as expected. The second parameter for the round() function is

Re: $$Excel-Macros$$ Help on a simple question

can you send the sample file of three reports with headers and final output On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques leote.w...@gmail.com wrote: I have a doubt dear friends, i have 3 reports i receive each month, so every month i have to to an overall report of the 3 like a database,

$$Excel-Macros$$ coping cells from one workbook to another, printing, deleting.....

i am saving info copied into a workbook then paste certain cells from the same row into another work book using 'paste special'. then i would like to print it, delete the pasted cell and move to the next row in the original workbook, paste it, print it and move on to the next row until the

Re: $$Excel-Macros$$ Help on a simple question

Thousands sorry ashish koul, this was a draft mail i sent by mistake, it was previous to $$Excel-Macros$$ Help on merging certain sheets to final workbook can you send the sample file of three reports with headers and final output On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques

$$Excel-Macros$$ Align cells with same value - vba almost working - please help

Hi cyberspace, I have spent quite some time trying to make this work but at this point from adding many msgbox checks, using the watch window for variables values everything seems coherent to me. I have 2 columns with sorted identical and not identical numercial values in both columns, see

Re: $$Excel-Macros$$ Need a Macro

This worked perfectly! Thank you! Sent from my iPhone On Mar 10, 2011, at 10:12 PM, Karla Haman karlaha...@hotmail.com wrote: I will give this a shot. Thank you so much. Sent from my iPhone On Mar 10, 2011, at 9:20 PM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, One approach

$$Excel-Macros$$ status of msgroups.net / registration fails / most recent posts are 06/2010

Hello, I was just wondering if the msgroups.net moved here in a formal or informal fashion. There isn't any status at msgroups.net saying it is for archive access only --- clearly the registration (at least for me) is broken. Server Error in '/' Application.

$$Excel-Macros$$ seeking MS documenation for OLEObject add button and OLE class definition

I am looking for detailed documentation on: ActiveSheet.OLEObjects.add(ClassType:=Forms.CommandButton.1) as well as the setting of .onAction which I can not set without error. I can not find base MS documentation for this OLEObjects.add construct, I can not find base MS documentation for the