Skip to content

Instantly share code, notes, and snippets.

@fuchao2012
Created April 10, 2018 16:01
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
生成保险费
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