Set range for macro running
Closed
a_elgazar
Posts
5
Registration date
Thursday October 27, 2016
Status
Member
Last seen
November 5, 2016
-
Oct 27, 2016 at 08:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 31, 2016 at 11:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 31, 2016 at 11:59 AM
Related:
- Set range for macro running
- No signal on monitor but cpu running - Guide
- No display on monitor but cpu running ✓ - Hardware Forum
- Pc fan running fast but no display ✓ - Motherboard Forum
- Selection.autofill destination:=range ✓ - Excel Forum
- Laptop fan running but no display - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Oct 27, 2016 at 10:58 AM
Oct 27, 2016 at 10:58 AM
Hi a_elgazar,
Start your code with:
If Target.Row < 9 then exit sub
Best regards,
Trowa
Start your code with:
If Target.Row < 9 then exit sub
Best regards,
Trowa
Oct 27, 2016 at 01:37 PM
but still i have problem want ask you about it ;
if i have ( b2-d2) merged
when i try the previous code tell me
unable to set the locked property in the range class
do you have an idea to solve this problem
Oct 31, 2016 at 11:59 AM
For that you will have to unmerge first, then lock/unlock cells and then merge again.
If you can't write that part of the code, then let me know which cells are merged (i.e.B2-D2 for 100 rows).
Best regards,
Trowa