Microsoft Recorder Needs to go on a Diet!

**JosephP** · 04-19-2012, 10:26 AM

actually for the macro recorder that's pretty good. no scrolling and so on. it basically just recorded exactly what you did as you did it. do you have a specific issue?

**Cyberpawz** · 04-19-2012, 10:48 AM

Originally Posted by JosephP

actually for the macro recorder that's pretty good. no scrolling and so on. it basically just recorded exactly what you did as you did it. do you have a specific issue?

The reason there is no scrolling is because I have everything viewed at 50% actual size so everything works as it is meant to.

Actually yes. I the cells are grouped, I need to only the first cell copied, then pasted, then continue down the path till it's all in a single row, then that is copied over to another sheet, and a numeric ID is given to said row.

The cells in question are B11, B14, B17, B20, B23, Q11, Q14, Q17, Q20, Q25, V23, V25, V27, B32, B36, B40, B44, B49, L49, V49.

They have to be in that order because this is part of a form, which will be pasted into a row, which will then be moved to a database style sheet, with a identifier at the beginning of said row. This row though will have to be at the end of all data.

So as you can see the program did what it was meant to, but it never would work the way that it needs to.

**JosephP** · 04-19-2012, 10:52 AM

Originally Posted by Cyberpawz

So as you can see the program did what it was meant to, but it never would work the way that it needs to.

that sounds like you're blaming the recorder for doing what it was meant to instead of something else that you hoped it might magically do. I don't see the connection to dieting.

**Cyberpawz** · 04-19-2012, 10:57 AM

Originally Posted by JosephP

that sounds like you're blaming the recorder for doing what it was meant to instead of something else that you hoped it might magically do. I don't see the connection to dieting.

Selection.Copy
    ActiveCell.Offset(46, 39).Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

You are telling me you couldn't write a better line of code to do the same thing?

**JosephP** · 04-19-2012, 11:19 AM

Originally Posted by Cyberpawz

Selection.Copy
    ActiveCell.Offset(46, 39).Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

You are telling me you couldn't write a better line of code to do the same thing?

I'm pretty sure I didn't tell you that but that's not the point. I know what the purpose is, the recorder doesn't. you're basically blaming a cassette recorder for recording you going "erm" instead of just playing the Gettysburg address like you meant.

**Cyberpawz** · 04-19-2012, 11:32 AM

Originally Posted by JosephP

I'm pretty sure I didn't tell you that but that's not the point. I know what the purpose is, the recorder doesn't. you're basically blaming a cassette recorder for recording you going "erm" instead of just playing the Gettysburg address like you meant.

Actually, I am expecting software that is meant to record something to do so without so much fluff. I remember recording scripts in AppleScript, and it was actually understandable... this is not.

**Cyberpawz** · 04-19-2012, 11:33 AM

Originally Posted by JosephP

I'm pretty sure I didn't tell you that but that's not the point. I know what the purpose is, the recorder doesn't. you're basically blaming a cassette recorder for recording you going "erm" instead of just playing the Gettysburg address like you meant.

Actually, I am expecting software that is meant to record something to do so without so much fluff. I remember recording scripts in AppleScript, and it was actually understandable... this is not.