I would like to use the following code but am getting an error when trying to insert a blank line?
Thanks so much in advance!
Sub Spacerz()
Dim Spacer As Range
'Insert New Line Seperator
For Each Spacer In ActiveSheet.Range("AB2:AB200")
If Spacer.Value = "0" Then Spacer.EntireRow.Insert
Next Spacer
End Sub
Hi, hftechno,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Again Worked like a charm!
Tried to show you some more reputation love but was unable to.
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks