Excel Macro
Solved/Closed
Related:
- Excel Macro
- Excel macro to create new sheet based on value in cells - Guide
- Excel macro auto increment number - Guide
- Excel macro create new workbook and copy data ✓ - Forum - Excel
- Excel macro compare two sheets and highlight differences ✓ - Forum - Excel
- Excel macro to create new workbook based on value in cells - Forum - Excel
1 reply
TrowaD
Jan 19, 2012 at 10:33 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jan 19, 2012 at 10:33 AM
Hello Macro Newbie,
Your problem is this line:
Trowa
Your problem is this line:
Rows("(x+12):(x+12)").SelectChange it into this:
Rows(x + 12).SelectBest regards,
Trowa
Feb 10, 2012 at 03:23 AM
It's now stalling at a similar line:
Range("a(x+12):q(x+12)").Select
Selection.Merge
where I am trying to merge columns A to Q on my row (x+12). Is there another way to describe this range?
Many thanks in advance for anyone's help on this again.
Regards.
Feb 13, 2012 at 10:06 AM
Range("A" & (x + 12) & ":Q" & (x + 12)).Select
I personally would use:
Range(Cells(x + 12, "A"), Cells(x + 12, "Q")).Select
Best regards,
Trowa
Feb 16, 2012 at 02:35 AM