Hi,
Although I see you have a solution, here is another that you can use without using the copy command ...
Just as another option. Take care.Sheets("Sheet2").Range("E5").Value = Sheets("Sheet1").Range("B4").Value![]()
Hi,
Although I see you have a solution, here is another that you can use without using the copy command ...
Just as another option. Take care.Sheets("Sheet2").Range("E5").Value = Sheets("Sheet1").Range("B4").Value![]()
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables