johnboy691 Posted September 21, 2007 Report Share Posted September 21, 2007 I have an Excel workbook open with data already populated on say...4 sheets. If I have my macro running and it needs to put information into say cell A1600 on Sheet one, whenever it does that, the same information shows up in the same cell in Sheet 2, 3 and 4 also. How can I prevent this. I've tried doing a text type with the information (ie: the word CONTINUE) I've tried putting the word CONTINUE into a variable and text typing the variable, and also pasting the variable from clipboard. Anyone have any ideas what I may be doing wrong...or what options I may need to change in excel? Thanks, John Quote Link to comment Share on other sites More sharing options...
Cory Posted September 21, 2007 Report Share Posted September 21, 2007 That doesn't sound right. I do stuff likethis all the time and don't have teh problem. Could you post an example with a small sample macro for me to debug? Thoughts: You dont' have worksheets but rather multiple 'views' open of the same spreadsheet. Or you have an =sheet1!A1 kind of formula. But I think you're clever enough to recognize these problems. Quote Link to comment Share on other sites More sharing options...
joe Posted September 21, 2007 Report Share Posted September 21, 2007 I agree with Cory. It sounds like you have a multiple-sheet formula going on there. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.