using windows clipboard for copying and pasting.
using windows clipboard for copying and pasting.
(OP)
HI
In VBA for Excel is it possible to mark a range, copy the values of the range to the clipboard and paste the contents again in another sheet of the same workbook. please help. I am thinking of alternatively storing the values of the range in an array and then copying the contents of the array back in another cell. thanx.
toparag.
In VBA for Excel is it possible to mark a range, copy the values of the range to the clipboard and paste the contents again in another sheet of the same workbook. please help. I am thinking of alternatively storing the values of the range in an array and then copying the contents of the array back in another cell. thanx.
toparag.
RE: using windows clipboard for copying and pasting.
Range("A1:A6").Select
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
Range("B7").Select
Ruairi
Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.
www.plccontroltechnologies.com