+ Reply to Thread
Results 1 to 4 of 4

Paste Values in Certainty Range

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Paste Values in Certainty Range

    hi all...

    i have found code to paste values in multiple sheets..
    this code working well
    Sub Saveasvalue()
    'Updateby Extendoffice 20161025
        Dim wsh As Worksheet
        For Each wsh In ThisWorkbook.Worksheets
            wsh.Cells.Copy
            wsh.Cells.PasteSpecial xlPasteValues
        Next
        Application.CutCopyMode = False
    End Sub
    but i want to paste value start from ONLY range A1 to F21 in sheet Hitung1, Hitung2, Hitung3, etc.....at once running code

    any help, thanks in advance...

    john m
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,124

    Re: Paste Values in Certainty Range

    How about
    Sub JhonMustofa()
       Dim Ws As Worksheet
       For Each Ws In Worksheets
          If Ws.Name Like "Hitung*" Then
             Ws.Range("A1:F21").Value = Ws.Range("A1:F21").Value
          End If
       Next Ws
    End Sub

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Paste Values in Certainty Range

    hi Fluff13, thank you it solved.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,124

    Re: Paste Values in Certainty Range

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to copy cells from a selected range and just paste values back to that same range
    By catscats11 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2019, 02:59 PM
  2. [SOLVED] Find last used row in a range, paste it 1 row down, paste copied row as values
    By ExcelEnthusiast7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-20-2018, 05:33 PM
  3. [SOLVED] Extract Some Text Certainty
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-13-2015, 11:48 PM
  4. [SOLVED] Paste Values from Range
    By asach1211 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2014, 04:38 PM
  5. [SOLVED] Copy and paste range as values to specific sheet/range
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 09:48 PM
  6. Paste as values macro where range(A1:row(A1)+Sum(D1:D5))?
    By Dwexdwex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2013, 12:41 PM
  7. How to use VBA to paste formula values to a range?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2010, 03:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1