tatrader Posted February 28, 2006 Report Share Posted February 28, 2006 I am trying to write a macro that sequentially reads and copies a series of 5 cells in a row of Excel into corresponding text variables. Activating Excel and locating the cells of interest is working ok. With a cell highlighted, I try to copy: text type macro: "controldown,C,countroup" I notice that Excel does not turn the frame around the selected cell to 'marching ants' when the macro attempts to copy it; however, marching ants does occur when I actually enter ctrlC on the keyboard. I then set a text variable with the contents of the clipboard, and I see from the debug variable table that no information resides in the text variable. I want to treat the copied value (shown as a number in Excel cell) as text so I can then paste it into another different application. Does it matter for copy into a text variable if numbers are shown in the Excel cell? What if the cell format is set to "text" in Excel? Help appreciated. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.