AnsweredAssumed Answered

vrf Active X Excel question.

Question asked by mrgold on Jun 12, 2002
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><META content="MSHTML 5.50.4807.2300" name=GENERATOR><STYLE></STYLE></HEAD><BODY bgColor=#ffffff><DIV><FONT size=2><P>I am trying to fill in an excel spread sheet with multiple sheets. i.e. each sheet is a different frequency. The fill part is working except that the select sheet selects the new sheet but the data continues to fill on sheet1. Anyone know how to change the fill to the next sheet?</P><P>'ExcelApp.Sheets(b).Activate' - where (b) is the sheet name. It sets it active but still writes to the first sheet only.</P><P>Thanks,</P><P>MG</P></FONT></DIV></BODY></HTML>  

Outcomes