You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- active cell copies
Excel/active cell copies
Advertisement
Question
I created a macro for 1250 tables. However, I would like the outcome to be stated in a table ranging A1-D52. Can I copy an active cell to, for example, C3, and go back to my active cell?
kind regards.
Hi Erik,
You should be able to do that using the relative cell reference when recording your macro, which will help you return to the current active cell.
The item that you'll need to explain a little better is with your outcome table. How do you select which cell to copy to? Obviously, it won't always go in to C3, but how do you want to choose the next cell for the next result?
-Craig
Related Articles
- Relative Cell Reference - Spreadsheets Terms - Relative Cell Reference Definition
- Absolute Cell Reference - Definition of Absolute Cell Reference - Spreadsheets Terms
- Spreadsheet Terms - Glossary - Excel - Range Definition
- Excel Name Box - Using the Name Box to Navigate an Excel Spreadsheet
- OpenOffice Calc Formula - OpenOffice Calc Formula Tutorial
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Craig
Expertise
I can answer most general questions, including formatting, shortcuts, pivot tables etc. I have just started using macros, so vba is not my strong suit. I also enjoy explaining the solution at the questioners level of understanding. I am an accountant by trade, so that is my primary area of expertise, but I am willing to tackle just about anything.
Experience
I've been working in excel for 15+ years
Education/Credentials
BA - Business '96, CPA '98
©2012 About.com, a part of The New York Times Company. All rights reserved.