Hello,

My macro updates information in another workbook without any errors however when doing so the screen updates even with screen updating set to false. I'm guessing this might be because of the activate events that i have in my code

[code]
Workbooks("database.xlsm").Sheets("Data").Activate
ActiveSheet.Range("H3:H1000").Find(What:=ComBoxExistingComponentName).Activate
ActiveCell.Value = TextBoxRevisedComponentName
[code]

I'm looking for suggestions on how to stop the screen updating or perhaps a more efficient way to structure the code that would let me update the necessary cells in the other workbook without having to activate the workbook and cells.

Thanks