Thread: Copying values and formatting but not formulae to new worksheet with VBA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ajkessel@gmail.com is offline
external usenet poster
  
Posts: 2
Default Copying values and formatting but not formulae to new worksheet with VBA
Thanks, that solves it exactly.

David wrote:
Rowan Drummond wrote

For Each cell In Sheets(1).UsedRange
cell.Value = cell.Value
Next cell

FWIW, my experience has been I can write this as:
Sheets(1).UsedRange.Value = Sheets(1).UsedRange.Value

--
David

Reply With QuoteReply With Quote