I have a lot of different recorded macros that do a lot of copying and pasting. I never really cared about the fact that these macros are probably not the most efficiently written code. But I watched a video about making your code run 1000 times faster and it has me thinking that maybe I should try to write the code better than what just gets recorded during the record macro - because some of my macro are slow.
Below is a simple recorded code. The video talked about assignments but I've tried to modify this code to what the person in the video was doing with no luck.
Is there a way to do assignments with this code?
Below is a simple recorded code. The video talked about assignments but I've tried to modify this code to what the person in the video was doing with no luck.
Is there a way to do assignments with this code?
VBA Code:
Sheets("Bid Sheet").Select
Range("K2").Select
Selection.Copy
Sheets("Bid Sheet-Org").Select
Range("K2").Select
ActiveSheet.Paste
