Posted to microsoft.public.excel.programming

Bill[_30_] Bill[_30_] is offline

external usenet poster

Posts: 89

Copying Question

Hello,
I have the code below:

ActiveCell.Offset(28, 0) = CS.Cells(i, 23)

Question: how can I move the formatting at the same time. When the CS.Cells
is a date, it gets set to the general format.

Thanks,

Bill

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying Dates Question	Von Fourche	Setting up and Configuration of Excel	6	September 6th 09 05:07 PM
Question on copying formulas	Meenie	Excel Worksheet Functions	1	February 13th 08 02:47 PM
Copying Formulas Question	Tom.	Excel Discussion (Misc queries)	4	April 24th 06 03:55 AM
copying formula question	DeeZi	Excel Discussion (Misc queries)	2	June 30th 05 09:41 PM
Copying and Pasting---Another question...	Tia	Excel Discussion (Misc queries)	1	June 7th 05 07:41 PM

All times are GMT +1. The time now is 01:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us