Sorry, I didn't explain the situation clearly enough. Plus I made a posting error. The code that I posted was recorded while working in "2018" worksheet. I right-clicked the worksheet name tab at...
Type: Posts; User: jarhtmd
Sorry, I didn't explain the situation clearly enough. Plus I made a posting error. The code that I posted was recorded while working in "2018" worksheet. I right-clicked the worksheet name tab at...
I have an Excel2007 workbook with several worksheets. Most of the sheets are named with the 4-digit year (2017, 2018, etc).
I recorded a macro to copy a worksheet and then do various things in the...
Thanks, Alan. I was looking right past it. As my Mom used to say, "If it had been a snake it would have bitten me". Thanks also for explaining code tags.
Using the (newly found) Excel options, I...
My worksheets don't auto complete as I type text into cells. I have not (knowingly) turned that off. It seems to be the same for all workbooks.
Googling yields . . . "Click the Microsoft Office...
Thanks for your reply. However, I need to move the cursor to that cell for data entry. I should have stated that.
I've discovered how to do just what I want (& more).
To move to the last cell...
How do I jump to the last populated cell in a column?
I don't understand this "answer" at all.
I need to know specifically what each of the possibilities are so that I will know that I have provided (outside of Excel) for every possibility.
I have 4 variables "L S K B", any or all of which may either be "on" or "off". I need to get all possible on/off combinations . . . "- S K B", "L - K B", "L - - B", "L - - -", etc.
Is there a...
Sorry, I've been away & haven't been able check & use this. Thanks a million. It will be very useful.
Thanks. That does exactly what I ask for. But . . . I asked for the wrong thing.
I apologize for not stating the situation more clearly.
This workbook contains worksheets for various...
I have a workbook with several worksheets. Col C (in all sheets) contains various dates (mm-dd-yyyy). I would like to name the various worksheets using the last 2 digits in the year portion of the...