VBA cpy & Paste

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: uziel_9@xxxxxxxxx
Date: 29 Jun 2005 04:33:18 -0700

Hi all,

Can I, using VBA, copy range A1:G1 and paste only the content of
the first three cells (A1:C1) to, let's say, A2:C2?

Thanx for your help,
Uziel

.

Follow-Ups:
- Re: VBA cpy & Paste
  - From: Dave Peterson

Prev by Date: Re: intersection
Next by Date: Re: Copy/Paste very slow with separate excel window
Previous by thread: intersection
Next by thread: Re: VBA cpy & Paste
Index(es):
- Date
- Thread

Relevant Pages

Re: Not allowing users to enter data into certain cells if another cel
... > Alok Joshi ... >> I would like to NOT allow the user to enter any data into cells ... >> Maybe this can be done with VBA?? ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: re calculating numbers to times
... simply add the cells. ... YOu may have to set the format of the ... >or better VBA? ... Prev by Date: ...
(microsoft.public.excel.misc)
Check cell formula
... I wanted to clear all the cells which have formula on it. ... Are there any function to check this like "Isformula" in VBA? ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: is it possible to select and change the values of cells in a minimized excel spread sheet from v
... >> is it possible to select and change the values of cells in a minimized ... >> spread sheet from vba? ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: VBA cpy & Paste
... > Can I, using VBA, copy range A1:G1 and paste only the content of ... Dave Peterson ... Prev by Date: ...
(microsoft.public.excel)