Its base on if the cell color is red, which I did try using with conditional formatting but it didn't work for me. Set b = Worksheets("Calc-Census - Current State").Range("A3:A65000")įor Each c In Worksheets("RAND_Input").Range("A3:L65000").Cells The error I am getting is 'Object variable or With block variable not set' is occupied, if it is, then I want to generate random numbers in Range A3 up to L65000 on the my current sheet (RAND_Input) depending on how many rows are occupied on Sheet1 I am attempting to have it check on one sheet (Sheet1) if A1, A2. I totally stole this code from another post and was adjusting it based on my parameters. I am pretty sure I am having an issue with the declarations but can't figure it out. Exception: : VBA error 91 (Object variable or With block variable not set) at. Okay so I am still not really picking up on the syntax of VBA coming from having heavy SQL experience. This issue was submitted by the add-ins exception handler.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |