AreYouLikeNew
New Member
- Joined
- Jul 3, 2018
- Messages
- 1
Hi all,
Suddenly today, the little cursor to drag down to fill has "stopped working". I have a VBA-defined Name which is called by "FontColor" in my function as in the picture (I had to block out sensitive info). The code for FontColor in my defined name is: GET.CELL(24,Sheet1!X3:X252). The result of the function should be 0,1, or blank, and it works (even with the self-referential cell=cell, which I later removed).
I've checked Preferences and made sure the option to do so is turned on, which it is of course, because I am constantly doing this. I didn't create the sheet but there are no permissions to be concerned about. I've played with filters, as that was something suggested as a solution elsewhere, but to no avail.
Please, if you know why the cursor no longer changes, and why Edit>fill down doesn't work either, let me know.
Thanks in advance!
[/URL][/IMG]
Suddenly today, the little cursor to drag down to fill has "stopped working". I have a VBA-defined Name which is called by "FontColor" in my function as in the picture (I had to block out sensitive info). The code for FontColor in my defined name is: GET.CELL(24,Sheet1!X3:X252). The result of the function should be 0,1, or blank, and it works (even with the self-referential cell=cell, which I later removed).
I've checked Preferences and made sure the option to do so is turned on, which it is of course, because I am constantly doing this. I didn't create the sheet but there are no permissions to be concerned about. I've played with filters, as that was something suggested as a solution elsewhere, but to no avail.
Please, if you know why the cursor no longer changes, and why Edit>fill down doesn't work either, let me know.
Thanks in advance!
