Using Ref edit in Add in to save to a different sheet.

C

c4clark

Hey, I have built an Add In and want to be able to save to a different sheet
than the one I opened the tool on. It keeps giving me an error: SELECT METHOD
OF RANGE CLASS FAILED. This seems odd since the REf Edit has both the sheet
and the cell in it? Any suggestions?
 
J

Jon Peltier

You have to split the sheet name from the address, and reference like

Worksheets("SheetName").Range("A2:Z50")

Also, if your code selects cells during the process (usually you should
program it not to do so), if the sheet you want isn't active or activated
first, you'll get an error using the select method, as you've found.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Emulating Ref Edit in VB6 2
Save with ref. to cell A1 2
Create a chart from a table in word thats dynamic 0
Saving file with ref. to one cell 0
(headers & footers Issue) I have 2 even pages back to back!! 1
Help with copying a sheet from One workbook to another workbook 1

Top