How I learned how to do these kind of items, is to go to under 'Tools', and
select 'Macro', and then select 'record new macro'. And then using your
mouse go through each step that you want to accomplish. When done, stop the
marco recorder, and hit the 'Alt Key' and 'F11 key' and you will see the
steps that was recorded.

Walter

"icanlearn" wrote:

Would like assistance in creating a macro that will copy a cell, then
edit/copy/paste special/multiply that cell to an unknown column and row area
(ie the spreadsheet may have more or less rows and columns each time the
macro is used). My worksheets often require the use of the #1 to convert
data downloaded from our systems.

icanlearn