Thread: [Solved] Need help creating vba code
View Single Post
 
Old 10-27-2019, 01:02 PM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 10 Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 115
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

Interesting because when I placed it in your workbook, it worked for me. Did you place the code in the regular module or in the worksheet event? This would make a big difference. To place in a worksheet event, open the VBE. In the left window click on the worksheet you have the data in. A window should open in the right side of your screen. Copy my code and paste it into that new window. Save and close. Now try it.
Reply With Quote