$$Excel-Macros$$ Re: paste multiple ranges in vba excel 2010

2013-11-17 Thread cristian paduraru
*To Basole,* I have tested Your Improved code and them working fine. I escape by the action of modifying the code every time before I wanted to apply on different values. Thank You Basole for Your Time. Iou saved-me of a lot of extra-work. All best wishes! vineri, 15 noiembrie 2013,

$$Excel-Macros$$ Re: paste multiple ranges in vba excel 2010

2013-11-17 Thread Basole
ok Cristian, not at all. tks, Basole. Em quarta-feira, 13 de novembro de 2013 04h14min03s UTC-2, cristian paduraru escreveu: Hello to You all, I encountered following issue: I want to copy multiple ranges and paste to it in the specific ranges. I will send you down the vba code:

Re: $$Excel-Macros$$ Date format_Not in Proper

2013-11-17 Thread Rajan sharma
Hi, Try using below: Sub prafu() For Each x In Range(A1:A9000) x.Value = Format(x.Value) x.Value = Format(x.Value, dd-mm- hh:mm) Next x End Sub With warm regards, Rajan Sharma On Mon, Nov 18, 2013 at 12:23 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Good

$$Excel-Macros$$ Re: [XL-VBA Clinic] Date format_Not in Proper

2013-11-17 Thread Prafull Jadhav
Hi Sir, Thanks for Reply.. I have try this but result is coming wrong ...as out put showing jan and Feb month also .. data is contain from April to Nov .. Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 1:02 PM, saurabh kumar saurabhkumar8...@gmail.comwrote: Hi Prafull,

Re: $$Excel-Macros$$ Date format_Not in Proper

2013-11-17 Thread Prafull Jadhav
DEAR RAJAN SIR, thanks for reply... but output showing jan and feb month also after running macro . Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 12:32 PM, Rajan sharma rajansharma9...@gmail.comwrote: Hi, Try using below: Sub prafu() For Each x In Range(A1:A9000)