Skip to content

Instantly share code, notes, and snippets.

@pogin503
Created March 13, 2013 10:14
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 pogin503/5150808 to your computer and use it in GitHub Desktop.
Save pogin503/5150808 to your computer and use it in GitHub Desktop.
関数名とかは適当
Sub test()
Call fillXtoY("", 0)
End Sub
Sub fillXtoY(x, y)
For i = Selection(1).Row To Selection(Selection.Count).Row
For j = Selection(1).Column To Selection(Selection.Count).Column
If Cells(i, j) = x Then
Cells(i, j) = y
End If
Next
Next
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment