Can't get .value=.value to work

Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Can't get .value=.value to work

Can anyone see why the "range value" section of this code won't work? I get
an object not defined error?

shtarray = Array("Sheet1", "Sheet5", "Sheet2", "Sheet3", "Sheet4")

For Each sh In ActiveWorkbook.Worksheets(shtarray)
sh.Range("A2:EC2").Copy

Set frng = sh.Range("A5:EC" & Data.Range("B65536").End(xlUp).Row)
frng.PasteSpecial Paste:=xlPasteFormulas

With ActiveWorkbook.sh.Range("A5:EC" &
Data.Range("B65536").End(xlUp).Row)
.Value = .Value
End With
Next sh

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
Macro to update a column in a work based on another work sheet	WickerMan	New Users to Excel	1	December 4th 09 12:58 PM
how can i automatically generate work order numbers from work orde	rob h	Excel Discussion (Misc queries)	1	July 13th 09 07:59 PM
flash object dont work in my excel work sheet	Nitn	Excel Discussion (Misc queries)	0	July 4th 09 08:00 AM
Counting dates in multiple work sheets and work books	Savage	Excel Discussion (Misc queries)	0	December 19th 05 11:41 PM
Is there away to keep "auto save" from jumping to the first work sheet in the work book?	Marc	New Users to Excel	2	April 21st 05 01:27 AM

All times are GMT +1. The time now is 10:40 PM.

Menu

About Us