Conditional Selecting for Macros

Juan Ricardo

New Member
Joined
Feb 1, 2014
Messages
1
Hi! I need your help to get this macro right.

I need to copy the formulas i have on a table as values on top of the original cells . How can I select the combination of columns and rows i want to select?

I dont want to copy the whole table , just a selection of the information contained in some rows and columns.

This table will change the number of rows depending on the amount of information to process so i need the macro to understand this .


Thanks!
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

KrisSquare

Board Regular
Joined
Feb 1, 2014
Messages
66
Try this

Sheets("SheetName<sheetname><yoursheet>").cells.SpecialCells(xlCellTypeFormulas).formula=Sheets("Sheetname<sheetname><yoursheet>").cells.SpecialCells(xlCellTypeFormulas).value</yoursheet></sheetname></yoursheet></sheetname>
 

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,467
How is Excel going to know which cells (rows/columns) to select? We need to know this first... Please provide this..
 

Watch MrExcel Video

Forum statistics

Threads
1,095,400
Messages
5,444,253
Members
405,278
Latest member
Rashford

This Week's Hot Topics

Top