tanzilhuda/gist:dc81359e726ca341a17feaae18747ada

Created August 5, 2020 20:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tanzilhuda/dc81359e726ca341a17feaae18747ada.js"></script>
Save tanzilhuda/dc81359e726ca341a17feaae18747ada to your computer and use it in GitHub Desktop.

Download ZIP

Rename Sheet basis of row or column name

Raw

gistfile1.txt

	Sub RenameSheet()

	Dim rs As Worksheet

	For Each rs In Sheets
	rs.Name = rs.Range("B2")
	Next rs

	End Sub

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment