Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Loading Excel sheet into Web component

Dim Rng As Range

For Each Rng In Sheet1.UsedRange.Cells
Spreadsheet1.Range((Rng.Address)).Value = Rng.Value
Next Rng


This code seems to be working well, is there anyway to keep the
formatting of the text?

Thanks so much.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Web Excel Component Bug [email protected] Excel Discussion (Misc queries) 1 May 11th 07 12:22 AM
Set up costing sheet for multiple component recipe. Jackam Excel Discussion (Misc queries) 1 September 27th 06 09:34 AM
Loading sheet names in Combobox Sige Excel Programming 5 September 16th 05 05:09 PM
Excel sheet not loading BurhanM Excel Discussion (Misc queries) 1 June 28th 05 11:48 AM
Loading Sheet Names into Combo Box ExcelMonkey[_156_] Excel Programming 6 September 15th 04 01:30 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"