Conditional Selecting for Macros

[Juan Ricardo]

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!

 

[KrisSquare]

Try this

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

 

[jim may]

How is Excel going to know which cells (rows/columns) to select? We need to know this first... Please provide this..