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
Bookmarks