Mac, Excel 2008, VB not supported
1. Tools->Macro->Visual Basic Editor
a) double click sheet1, copy following VB code:
------------------------------------
Sub proFirst()
Range("A1").Value = 34
Range("A2").Value = 66
Range("A3").Formula = "=A1+A2"
Range("A1").Select
End Sub
-------------------------------------
b) Recording Macro: Click Run-> Run Sub(F5)
In sheet 1, Column 1, 34,66 and 100 are shown
2. Tools->New Macro
In working sheet, type A1->100, B1->1000
A2->20, B2->15
stop recording macro
go to Visual basic editor,
Module->Module1, the following code can be seen
-------------------------------
Sub Macro1()
'
' Macro1 Macro
' Macro recorded by Jiansen Lu
'
'
ActiveCell.FormulaR1C1 = "100"
Range("B1").Select
ActiveCell.FormulaR1C1 = "1000"
Range("A2").Select
ActiveCell.FormulaR1C1 = "20"
Range("B2").Select
ActiveCell.FormulaR1C1 = "15"
End Sub
-----------------------------------------------
Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- How to blend adsense inside your post?
- Formatting my post
- Notepad++ - Add C++ compiler
- Install PHPMailer 5.2.4 and use smtp gmail
- Datatable export excel wraptext and newline
- phpexcel toggle expand and hide column in EXCEL and summary
- Linux, automatically backup MySQL database daily
- SPSS job interview questions
- Install PHP ibm_db2 extension in Linux (redHat)
No comments:
Post a Comment