Excel MAcros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the functions shown in various texts on Macros to work in XL?
 
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.
 
Cells(Selection.Row, 1).Value = ????


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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TWO Instances of Excel One watching Other 3
Run Macro If Cell have "x" value 0
How to store values in excel using macro ? 4
Issue with TextFrame2: Library not found 2
When something in module is shown as a macro 3
Send mail code from Ron 1
Which Excel event to call when opening a .txt file 1
How to force macros refer to ActiveWorkbook 2

Back
Top