as per my understanding its not possible ... we need to create SUB or sort
data before paste special or
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 PM, Manoj Kumar wrote:
> Hi Team
>
> Can anyone suggest me that. How can I paste data using skip blank.
> That all
Hi Team
Can anyone suggest me that. How can I paste data using skip blank.
That all the blank cell ignore and data comes in series.
Please help me on this.
Thanks
Manoj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pa
Nevermind, I got it. For some reason there was a bunch of used rows in
there.
On Friday, October 18, 2013 7:21:50 AM UTC-7, Justin Pulley wrote:
>
> So I am going to have to upload the entire sheet I guess because when I
> run your code in the full workbook I end up with 5 blank pages of empty
Would anyone know how to change or control where the vlookup window opens
in code?
On Tuesday, October 15, 2013 9:52:24 AM UTC-4, dr wrote:
> I got the following code to work:
>
> Application.SendKeys ("%mf")
> Application.SendKeys ("vlookup")
> Application.SendKeys ("{ENTER}")
> Application.
PFA , If data in same format in all PFD so u can use this also.
You have to put acrobat reader exe path in coding.
MyPath = "C:\Program Files\Adobe\Reader 11.0\Reader\AcroRd32.exe"
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jocky Beta
Sent:
On Wed, Oct 16, 2013 at 8:29 PM, Secret Shot wrote:
> Dear Exterts,
>
> I am stuck in my project and need your expert advice that ho can i prevent
> duplicate data entry in any colom, but i have to use list validation too at
> the same time
>
> So for example my source range is G1:G10 on the basi
Hi Bs,
Thanks for the reply. I had check the Excel sheet on windows XP and it's
working fine, But i have instilled Windows 7 -64 Bit. In windows 7 64 bit
it shows same error. Hence request you to kindly assist/ Guide me for howto
opening the same on Windows 7 - 64 bit.
Waiting for your reply.
Re