|
Excel MAcros
How do I get the functions shown in various texts on Macros to work in XL?
|
Excel MAcros
Im not sure If I understand the question.. -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=27593 |
Excel MAcros
I'm trying to write a macro that looks at the current cell location in order
to move the data into col A. I used the macro record feature and then tried to edit the result into a macro that can be used from any cell location. The macro line: Range("A" & Text(Row(), "##")).Select.ActiveSheet.Paste does not work because Text(Row(), "##") is not compilable BUT it works on the spreadsheet. "Mcasteel" wrote: Im not sure If I understand the question... -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=275930 |
Excel MAcros
Cells(Selection.Row, 1).Value = ???? On Sat, 6 Nov 2004 14:33:03 -0800, Buzzsg wrote: I'm trying to write a macro that looks at the current cell location in order to move the data into col A. I used the macro record feature and then tried to edit the result into a macro that can be used from any cell location. The macro line: Range("A" & Text(Row(), "##")).Select.ActiveSheet.Paste does not work because Text(Row(), "##") is not compilable BUT it works on the spreadsheet. "Mcasteel" wrote: Im not sure If I understand the question... -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=275930 |
| All times are GMT +1. The time now is 07:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com