learning macros please help
Posted by George on October 23, 2000 5:16 PM
I am new to this so this is probably easy i just
don't get it. I am learning how write my own macros
or at least trying. See my mess below
I want to check if a cell has a currency format
then i want to start a macro to paste special
(which i recorded). I tried to combine them but it
doesn't work. I also want to multiply the active cell
by 106 (to get to yen from dollars).
it doesn't like the cell("format",d31)...line which works in a
straight formula. I would also like to change d31
above to represent any current cell (so i can run it over
the whole spreadsheet).
for example if d31 is $5 and d32 is $7 i want those cells
to be 530 and 742, respectively and to get the format
from the paste special macro i recorded.
For Each cell In Selection
If (cell("format", d31) = "C0" Or cell("format", d31) = "C1") Then
With cell * 106
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _