Excel Help.Clean.xlsmExcel Help.Clean.xlsmHey everyone,
I'm looking for a better way to increase the speed of the macro code (referenced below). I was just curious if there were any other formulas or tricks I could use. It currently performs a loop bw every cell in a range C2:F32. It takes about 10 seconds on average for every score aka "macro run" to transfer over. It currently isn't that bad with the # of questions I have, but I'm working on a project where I would need to add additional questions, and I'm thinking that the 10 seconds for every questions may become cumbersome. Any help would defiantly be appreciated it!
"Sub MacroLog()
Dim rcell As Range
For Each rcell In Sheets("Scoring").Range("C2:F32")
If rcell.Value = "" Then
Sheets("Scoring (2)").Cells(rcell.Row, rcell.Column).Copy
rcell.PasteSpecial xlFormulas
End If
Next rcell
Sheets("Scoring").Select
Range("C2:F32").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Response Tool").Select
Range("C5").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("D1").Select
End Sub"
Bookmarks