65535 excel numbers for mac3/29/2023 ![]() ![]() ![]() In that window choose control (the last item in the top row)Īgain right click the spinner button and click "assign macro" Right click the button and click "format control" In the list of form toolbars there is one called spinner ![]() Set cfind(k) = Columns("A:A").Cells.FindNext(cfind(k)) Set cfind(k) = Columns("A:A").Cells.Find(what:=x, lookat:=xlWhole) MsgBox "no such value is available in column A" J = WorksheetFunction.CountIf(Columns("A:A"), x) I shall give another solution print these instructions and follow(provided it suits you)ĭim x As Integer, cfind() As Range, j As Integer, k As Integer, add As StringĬolumns("A:A").Interior.ColorIndex = xlNone ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |