$$Excel-Macros$$ Regarding paste options

Dear All, I have a range. In that range when i select some range of numbers from other sheets and paste it in then present range or cell by right click or by just pressing cltr+V , then it should directly paste it as values. Is there any idea -- Thanks Regards, Gawli Anil Narayan

Re: $$Excel-Macros$$ Regarding paste options

In Excel 2010, On Keyboard, press right click, then press V. In Excel 2007, On Keyboard, press right click, then press S, then press V. If above process is not working. then I am unable to getting that what are you trying to say or I am not getting it at my level. Regards, Waseem Saifi On Tue,

$$Excel-Macros$$ Pivot Table Running Balance - Grand Total

I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should

$$Excel-Macros$$ Run time error 6

Hi, While running macro am getting run time error 6 as shown in the attached file. I am using huge data which contains 9 rows. Could you please let me know how to run macro with hugre data. Thanks, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Screen Updating

Hello Experts, i have a sheet am working in, when i press enter in the sheet, the screen sort of updates and flickers, how do i stop this. it is not VBA that i have to place application.screenupdating =false. how do i stop the anomaly. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Screen Updating

Hi Hilary, can u share the file..? Thanks Regards, Prabhu R On 13 August 2013 21:51, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i have a sheet am working in, when i press enter in the sheet, the screen sort of updates and flickers, how do i stop this. it is not VBA that i

$$Excel-Macros$$ Re: DATE Conversion - Gregorian to Hijri

Pls try with this file . It will convert Hijri date to Gregorian date format. Hansel On Tuesday, September 25, 2012 1:58:02 PM UTC+4, kothakota wrote: Dear All, Please find attach the Raw Data sheet from which I need to convert a Gregorian Date to a Hijri Date and pull out the Day,

$$Excel-Macros$$ Re: Idle timer that saves, closes and logs off user after 5 min

You can try below link: http://www.vbaexpress.com/kb/getarticle.php?kb_id=515 On Wednesday, 14 August 2013 03:36:42 UTC+5:30, Tom B. wrote: Hi I have a spreadsheet that records user inputs and then stores the inputs along with Date/Time and user ID. Since this will be accessed on

$$Excel-Macros$$ Re: Run time error 6

Instead of sharing Screen shot it would be nice if you can share file On Tuesday, 13 August 2013 20:01:06 UTC+5:30, Chandru wrote: Hi, While running macro am getting run time error 6 as shown in the attached file. I am using huge data which contains 9 rows. Could you please let me

Re: $$Excel-Macros$$ Screen Updating

There is too many reference to external files which makes WS unstable. Try to break un wanted reference, this may help. Thanks//Vabs On Tue, Aug 13, 2013 at 10:08 PM, Hilary Lomotey resp...@gmail.com wrote: PFA On Tue, Aug 13, 2013 at 5:35 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi