Hi,
This is probably a real easy question. Sorry I am a newbie.
I have a workbook that has multiple sheets in it. I would like to run a VB macro that reads data from one sheet and then updates data on another sheet.
I found that using thew following command
Sheets("Sheet2").Select
GrabData=Cells(row,column).value
grabbing the data then going back to the orginal sheet
Sheets("Sheet1").Select
Works....BUT it causes a flash on the screen when I run the script. Is there a better / easier way of doing this?
Thanks,
-Paul
This is probably a real easy question. Sorry I am a newbie.
I have a workbook that has multiple sheets in it. I would like to run a VB macro that reads data from one sheet and then updates data on another sheet.
I found that using thew following command
Sheets("Sheet2").Select
GrabData=Cells(row,column).value
grabbing the data then going back to the orginal sheet
Sheets("Sheet1").Select
Works....BUT it causes a flash on the screen when I run the script. Is there a better / easier way of doing this?
Thanks,
-Paul