Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Assign Data To A Cell
All,
I would appreciate your help, I already put this post up yesterday, though Mark replied his response unfortunatly did not solve the problem. In my VBA code I assign data to cells, which works fine for me, but when my colleague tries my VBA code on his PC it doesnt work. This code is displayed below: Cells(MyRow, MyCol) = MyOutput When I have stepped through this on my colleagues computer the variables MyRow, MyCol and MyOutput have the correct values to assign the output to the cell but it fails to do so. We have both declared the variables being used and our lines of code do begin with "Option Excplicit". There is a workbook / worksheet open and hence active. I have also noticed that I am unable to edit the value of the cell when I have added that cell to the 'Watches' in the VBA Editor. Thanks Aanika |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Assign Data To A Cell
Since you didn't keep the other reply I don't have any
idea what he said.. Perhaps if you are more explicit in your assignment it will work. Cells(MyRow, MyCol).Value = MyOutput ------- original message -------------------------------- All, I would appreciate your help, I already put this post up yesterday, though Mark replied his response unfortunatly did not solve the problem. In my VBA code I assign data to cells, which works fine for me, but when my colleague tries my VBA code on his PC it doesnt work. This code is displayed below: Cells(MyRow, MyCol) = MyOutput When I have stepped through this on my colleagues computer the variables MyRow, MyCol and MyOutput have the correct values to assign the output to the cell but it fails to do so. We have both declared the variables being used and our lines of code do begin with "Option Excplicit". There is a workbook / worksheet open and hence active. I have also noticed that I am unable to edit the value of the cell when I have added that cell to the 'Watches' in the VBA Editor. Thanks Aanika |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I assign a data for one cell from another fixed cell? | New Users to Excel | |||
Unable to delete html data pasted into a cell | Excel Discussion (Misc queries) | |||
How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
unable to change data in cell(s) | Excel Discussion (Misc queries) | |||
Unable to Assign Value To Cell | Excel Programming |