VBA

F

FLKULCHAR

I received an answer to my yesterday query which included using a VBA
procedure.

I have NO idea what a VBA procedure is.

Please explain.

FL Kulchar
 
P

Peo Sjoblom

1.

You seem to assume we all know what question you posted and why you received
an answer using VBA. Post a follow up in the same thread so anyone can see
what went on before.
You could at least (assuming you have access to the internet) do
www.google.com search, go to microsoft.com and type in VBA procedure in the
search box

here's a link that might be of some use

http://www.excel-vba.com/


Regards,

Peo Sjoblom
 
F

FLKULCHAR

To: Mr. Peo:

Here is my original posting:
Every evening, I copy and paste a column of numbers into a row of
numbers...from one workbook to another, using the PASTE SPECIAL, TRANSPOSE
capabilities of EXCEL.

Since I do this EVERY DAY, is there a way I can bypass the PASTE SPECIAL
command via some instruction.thus telling the command to copy into a row
instead of a column?

In other words, I would like to speed up the process, click on the leading
cell, and then copy (what was once a column in another worksheet into a row
on my new workbook).

Thanks,

Any pointers??

FL Kulchar


Was this post helpful to you?
Reply Top





R.VENKATARAMAN

12/28/2004 7:39 PM PST
Re: Paste Special

In: microsoft.public.excel.misc



create a vba procedure like this

Public Sub test()
Range("d5:d10").Copy
Workbooks("book2").Worksheets("sheet1").Range("B4"). _
PasteSpecial xlPasteValues, Transpose:=True
End Sub

this sub is placed on the vbeditor of book1 where the column data is located
customise the sub to suit your needs.
your original data is in sheet1 and range d5 to d10
the data to be copied to book2, sheet1 and from B4
================
FLKULCHAR said:
Every evening, I copy and paste a column of numbers into a row of
numbers...from one workbook to another, using the PASTE SPECIAL, TRANSPOSE
capabilities of EXCEL.

Since I do this EVERY DAY, is there a way I can bypass the PASTE SPECIAL
command via some instruction.thus telling the command to copy into a row
instead of a column?

In other words, I would like to speed up the process, click on the leading
cell, and then copy (what was once a column in another worksheet into a row
on my new workbook).

Thanks,

Any pointers??

FL Kulchar
Click to expand...






I HAVE NO IDEA HOW TO DO THIS AS I AM NOT FAMILIAR WITH VBA!!

Please advise.
 
Top