I have a question regarding AutoFill and Copy/Paste. When I want to have a VBA Code that copies a cell format into another cell. However, a problem seems to occur when I paste into cells that are already filled with values. Excel has an error and crashes, so I dont have an error message to this. The same happens when I use AutoFill.
Here's my code:
wb1 and wbdata are two differnt worksheets. u and i are variables that determine the last filled row in wb1 resp. wbdata. The code works fine for the first two lines shows here (Pasting into empty row), but yields an error when I use the last two lines.
Please Login or Register to view this content.
Would be great if someone could help me on this!