Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel MAcros
How do I get the functions shown in various texts on Macros to work in XL?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Making excel macros run Word macros | Excel Programming |