i need to copt two or more excel files into one excel file
On May 5, 8:56 pm, yogesh yerawar wrote:
> Hi,
>
> copy filename destination path
>
> eg.
> copy book1.xls c:\my documents
>
> 2009/5/5 singla.kris...@gmail.com
>
>
>
> > Hi eveybody,
>
> > can anyone tell me how to copy excel files usi
n manually.
Thanks for your help in advance,
__ ESET NOD32 Antivirus - Vírusdefiníciós adatbázis: 4052 (20090504)
__
Az üzenetet az ESET NOD32 Antivirus ellenõrizte.
http://www.eset.hu
__ ESET NOD32 Antivirus - Vírusdefiníciós adatbázis: 4054 (200905
Thanks. My data is mostly larger than 100 cells. how can I increase the
varGroupSize to 200?
Thanks,
Mike
On Tue, May 5, 2009 at 2:38 PM, Fabio Lemos wrote:
> Ok.
> That's possible too...
>
>
> There is a named range (a value in this case) that put a limit on each
> block size if you set i
Hi, try this code somewhere in your sub:
With Range(A1:A1000)
D = "Seed-BOD"
Set C = .Find(D, LookIn:=xlFormulas)
If Not C Is Nothing Then MsgBox "Sample is already here."
End With
If you are already using C and/or D as variables, you'll need to change them.
You may need to cha
Hi,
copy filename destination path
eg.
copy book1.xls c:\my documents
2009/5/5 singla.kris...@gmail.com
>
> Hi eveybody,
>
> can anyone tell me how to copy excel files using command prompt.
>
> thanx in advance
>
> >
>
--
Thanks and Regards,
Yogesh Yerawar
--~--~-~--~~
Hi eveybody,
can anyone tell me how to copy excel files using command prompt.
thanx in advance
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutor
Hi Skanda,
Please find the attached solution.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Sat, May 2, 2009 at 1:24 AM, Skanda wrote:
> Columns A and B give the sum of ceizg and
Ok.
That's possible too...
There is a named range (a value in this case) that put a limit on each block
size if you set it to a very large number the calculation will last
longer (varGroupSize that is set to 100).
If you need to increase it you can.
Regards!
2009/5/5 Michael Fowler
>
Seems easy enough but I'm new at VBA so I can't seem to get it right.
I have a sub that adds a row to my worksheet but this particular row
needs to be unique. So all I want to do is call a function that will
search the first column of the active worksheet for the string "Seed-
BOD". If it finds t
Thanks Fabio.
But, this doesn't take into account only the range UNTIL the next blank. I
have made a sheet from your that shows three groups of data. The cell
calling the random data is taking into account ALL of the data. Can this be
limited to only each group and only to the next blank cell (aft
Yes, but I have multiple ranges in the worksheet (250+) with each range
having a different number of rows. If I use the index method:
=INDEX(A2:A171,RANDBETWEEN(1,169)), then I am forced to select the range AND
also to count how many total cells are in the range.
What I need to do is to do this by
selcet column & press shift+ctrl ) for hide & unhide shift+ctrl (
On 5/5/09, shafiq online wrote:
>
>
> Can anyone tell me how can I hide row and column heading?... I mean calumn
> names for example a.b.c.d in default and row names 1 2 3 etc.
>
> Regards
>
>
> --
> See
Hi Shafiq,
If you are using Excel 2003 then follow the steps below:
1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "View" tab.
3. Under "Window Options", check or uncheck "Row & column headers" as
desired.
4. Click "OK" to close the dialog box.
Re
13 matches
Mail list logo
