![]() |
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 |
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 |
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