Choose multiple start and end position of window in a row...

p45cal · #1 04-01-2019, 05:22 AM

Not one cell at a time:

Quote:

Originally Posted by p45cal

Array-enter it (use Ctrl+Shift+Enter, not just Enter, when committing the formula to the sheet). Do this with all 4 cells selected as you enter the formula.

xor · #2 04-01-2019, 06:58 AM

I hope p45cal will accept that I make use of his formula in #3.

If so and if you can accept some helper cells the following might be of some interest.

p45cal · #3 04-01-2019, 08:12 AM

Quote:

Originally Posted by xor

I hope p45cal will accept that I make use of his formula in #3.

Where I struggled with the formula was it not detecting when the value in A2 was not zero. It looks like you've inherited that problem!

Ganesh Kumar · #4 04-01-2019, 07:05 AM

Quote:

Originally Posted by p45cal

Not one cell at a time:

Thanks a lot...Great piece of code...Happy Knowledge Sharing...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I make Word remember the window size and position for each document?	Jennifer Murphy	Word	4	02-20-2023 06:36 PM
Creation of a multiple choose to create chapters	Xorre	Word VBA	1	01-06-2017 01:39 AM
Start from the previous position	Dimsok	Word VBA	7	09-14-2014 06:07 AM
Justify Paragraph Start position with VBA	jeff_kaufman	Word VBA	2	11-09-2013 12:15 PM
DL envelope window position	rogerwilding	Word	1	02-20-2013 01:57 PM