![]() ![]() If indRefColor = Selection(indCurCell). Then IndRefColor = cellsColorSample.Cells(1, 1). If Not (cellsColorSample Is Nothing) Then "Select sample color:", "Select a cell with sample color", _, Type:=8)Īny ideas what I need to change? I'm sorry but I know little of VB Scripting so I'm just trying to follow directions here. Set cellsColorSample = Application.InputBox( _ I'm currently trying to use it and I have followed the steps as written but when I go to the run the macro I get a syntax error on this line: Two best ways to convert numbers to words in Excel.How to count and sum cells by color in Excel - VBA macro.Then select the wanted macro from the "Macro Name" list and click the "Run" button. When you want to run the VBA code that you added as described in the section above: press Alt+F8 to open the " Macro" dialog. Press Alt + Q to close the Editor window and switch back to your workbook.Choose " Excel macro-enabled workbook" from the " Save as type" drop-down list and click the Save button. ![]() Press Crl + S, then click the " No" button in the " The following features cannot be saved in macro-free workbook" warning dialog.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |