Directional macro
Closed
kalignify
-
Jun 7, 2009 at 02:28 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 8, 2009 at 06:14 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 8, 2009 at 06:14 AM
Related:
- Directional macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
3 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 7, 2009 at 05:12 AM
Jun 7, 2009 at 05:12 AM
Hi
before pasting to a new sheet, just put the row and column number to variables and after pasting retrieve them
before pasting to a new sheet, just put the row and column number to variables and after pasting retrieve them
Thanks, but I'm not sure how to turn the cells to variables. I'm pretty new with macros. Would I be assigning each row/column a variable? Or each cell? And then I would instruct the macro to go to the assigned variable? Do you know the written command for this off-hand?
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 8, 2009 at 06:14 AM
Jun 8, 2009 at 06:14 AM
Hi
"I am able to do the "find" function and position myself to the correct row. In that row, I want to copy 4 different cells and paste it in another sheet. "
Here when you are in the first cell to copy, put the current column to a variable and row number to another variable. then copy and paste the data. Then go to the cell whose reference you now stored in variables and go to the next cell copy and continue like that...
"I am able to do the "find" function and position myself to the correct row. In that row, I want to copy 4 different cells and paste it in another sheet. "
Here when you are in the first cell to copy, put the current column to a variable and row number to another variable. then copy and paste the data. Then go to the cell whose reference you now stored in variables and go to the next cell copy and continue like that...
