Question:
Excel 4.0 Macro Question?
nDn.DiVa
2008-06-17 16:00:54 UTC
have an Excel Macro written in Excel 4.0 that I am updating. In the process, I have come across a function and am unsure of how to translate it over to Excel 2003.
The function is:
=PASTE.SPECIAL(3,1,FALSE,FALSE)
Three answers:
gasukegon
2008-06-19 17:45:12 UTC
I hunted down the Excel 4.0 Macro Reference file and found the explanation for the PASTE.SPECIAL.



Here is the equivalent of what you posted for the PASTE.SPECIAL (you will need to change the CopyToCell and CopyFromCell to whatever is in your program):



CopyToCell = CopyFromCell.PasteSpecial(xlPasteValues, xlPasteSpecialOperationNone, False, False)





** Here is the documentation on Excel 4.0 Macro's PASTE.SPECIAL Function if you need it:**



PASTE.SPECIAL(paste_num, operation_num, skip_blanks, transpose)



Paste_num is a number from 1 to 5 specifying what to paste. Paste_num can also be quoted text of the object you want to paste.



Paste_num Pastes

1 All

2 Formulas

3 Values

4 Formats

5 Notes



Operation_num is a number from 1 to 5 specifying which operation to perform when pasting.



Operation_num Action

1 None

2 Add

3 Subtract

4 Multiply

5 Divide



Skip_blanks is a logical value corresponding to the Skip Blanks check box in the Paste Special dialog box.



If skip_blanks is TRUE, Microsoft Excel skips blanks in the copy area when pasting.

If skip_blanks is FALSE, Microsoft Excel pastes normally.



Transpose is a logical value corresponding to the Transpose check box in the Paste Special dialog box.



If transpose is TRUE, Microsoft Excel transposes rows and columns when pasting.

If transpose is FALSE, Microsoft Excel pastes normally.
?
2016-12-10 12:29:10 UTC
To create your macro: a million. initiate recording your macro. Navigation to do this relies upon on what version of Excel you're utilising. For 2003 its equipment -> Macro -> checklist new macro. 2. spotlight the comprehensive column you desire to accomplish the replace on. 3. click Cntrl + F to open the discover/replace talk. click on the replace tab and enter your discover what and replace with values. 4. end the macro from recording. For 2003 its equipment -> Macro -> end Recording. Your macro is now comprehensive. To edit your macro: a million. For 2003, navigate to equipment -> Macro -> Macros. choose the macro you created and click edit. It opens your macro code. 2. discover the place it says determination.replace What:= and replace it the quoted text textile with the recent text textile you desire to hunt. Do an identical element with the replace:= section. 3. shop your transformations and your macros is as much as date.
fanslow
2016-12-16 00:36:01 UTC
Excel 4.0


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...