Skip to content

Instantly share code, notes, and snippets.

@fuchao2012
Created April 10, 2018 16:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fuchao2012/339340a223dcc180a12002e712cc449b to your computer and use it in GitHub Desktop.
Save fuchao2012/339340a223dcc180a12002e712cc449b to your computer and use it in GitHub Desktop.
生成保险费
Sub 保险费()
'
' 宏5 宏
'
selectionColumnCount = Selection.Count
For i = 1 To selectionColumnCount
ActiveCell.Value = "保险费、车船税来票-售后回租 专" & ActiveCell.Value
ActiveCell.Offset(1, 0).Range("A1").Select
Next
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment