shankar
04-17-2009, 03:31 AM
I am working on a VBA project which I would be converting into an add-in later. I read that any sheet in ThisWorkbook cannot be activated in an add-in. Does this mean that I cannot use statements like ThisWorkbook.Sheets("Sheet1").Select? Does selecting a sheet require it to also be activated?
Selecting the sheet means I can avoid With/End With and periods in front of Range or Cells (a minor inconvenience). But if selecting wouldn't work later with an add-in, I guess I would code it in the above manner. Thanks.
Shankar
Selecting the sheet means I can avoid With/End With and periods in front of Range or Cells (a minor inconvenience). But if selecting wouldn't work later with an add-in, I guess I would code it in the above manner. Thanks.
Shankar