+ Reply to Thread
Results 1 to 3 of 3

Macro Copy, PasteSpecial and conditional formatting CountIf

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    Bratislava
    MS-Off Ver
    2016
    Posts
    2

    Lightbulb Macro Copy, PasteSpecial and conditional formatting CountIf

    I wrote a code (below). Having problems getting values from one worksheet's cells (where i used conditional formatting "CountIf") to another worksheet's cells. If i used my code (copy and paste special values) the cells have zero value.

    Can you help me?? I'm only a beginner in VBA

    Sub Vysledky_macro()
    ThisWorkbook.Sheets("Odpovede").Select
    Range("H2").Select
    Selection.Copy
    ThisWorkbook.Sheets("Test").Activate
    Range("H44").Select
    Selection.PasteSpecial
    ThisWorkbook.Sheets("Odpovede").Select
    Range("H3").Select
    Selection.Copy
    ThisWorkbook.Sheets("Test").Activate
    Range("H45").Select
    Selection.PasteSpecial
    End Sub
    Attached Files Attached Files
    Last edited by Nippinka; 08-19-2016 at 04:55 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Macro Copy, PasteSpecial and conditional formatting CountIf

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.

    PS Can you add code tags when posting code?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-19-2016
    Location
    Bratislava
    MS-Off Ver
    2016
    Posts
    2

    Re: Macro Copy, PasteSpecial and conditional formatting CountIf

    i uploaded it, thanks for notice i'll look at it

+ 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. Debugging Macro to Copy over just Conditional Formatting
    By aadilshakir in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2015, 02:09 PM
  2. [SOLVED] Conditional Formatting is not transfering with Copy - Pastespecial Paste xlFormats
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2013, 07:34 PM
  3. Copying Values and Formatting without Copy/PasteSpecial
    By bungeejumper2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2012, 04:26 PM
  4. Conditional Formatting out of order after PasteSpecial
    By yjbrody in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2010, 01:29 PM
  5. Replies: 1
    Last Post: 07-07-2009, 04:51 PM
  6. [SOLVED] Countif and conditional formatting
    By SLKPM in forum Excel General
    Replies: 0
    Last Post: 09-30-2005, 06:05 AM
  7. Countif with conditional formatting
    By Johnny in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2005, 08:06 AM

Tags for this Thread

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