ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What's wrong? (https://www.excelbanter.com/excel-programming/317841-whats-wrong.html)

newbie

What's wrong?
 
Can someone please tell me what's wrong with this code?

Workbooks(v).Sheets(a).Cells(5, 5) = "=" & Workbooks(y).Sheets(a).Cells(39,
4) & "+" & Workbooks(y).Sheets(a).Cells(40, 4)

TIA

Bob Phillips[_6_]

What's wrong?
 
Nothing in itself. What is in the 2 cells, and what happens for you?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Newbie" wrote in message
...
Can someone please tell me what's wrong with this code?

Workbooks(v).Sheets(a).Cells(5, 5) = "=" &

Workbooks(y).Sheets(a).Cells(39,
4) & "+" & Workbooks(y).Sheets(a).Cells(40, 4)

TIA




Don Guillett[_4_]

What's wrong?
 
It depends on the rest of the code.
maybe

"v.xls"
"a"
cells(5,5).value

--
Don Guillett
SalesAid Software

"Newbie" wrote in message
...
Can someone please tell me what's wrong with this code?

Workbooks(v).Sheets(a).Cells(5, 5) = "=" &

Workbooks(y).Sheets(a).Cells(39,
4) & "+" & Workbooks(y).Sheets(a).Cells(40, 4)

TIA





All times are GMT +1. The time now is 09:44 AM.

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