ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   return a value from VB to a spreadsheet (https://www.excelbanter.com/excel-programming/278284-return-value-vbulletin-spreadsheet.html)

Punx

return a value from VB to a spreadsheet
 
How can I return a value from a VB script (variable text
string) to a specific cell on a specific page on my
worksheet.

any help would be great!!!


Bob Phillips[_5_]

return a value from VB to a spreadsheet
 
Punx,

Try

Worksheets("Sheet1").Range("A1").Value = myVariable

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Punx" wrote in message
...
How can I return a value from a VB script (variable text
string) to a specific cell on a specific page on my
worksheet.

any help would be great!!!





All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com