Incrementing the column at regular intervals
Closed
Arun
-
Oct 15, 2015 at 07:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 15, 2015 at 11:30 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 15, 2015 at 11:30 AM
Related:
- Incrementing the column at regular intervals
- How to get regular flash on snapchat android - Guide
- Excel copy column from one sheet to another automatically - Guide
- Count the number of times a value appears in a column ✓ - Office Software Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Sum column if another column equals ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 15, 2015 at 11:30 AM
Oct 15, 2015 at 11:30 AM
Hi Arun,
Not exactly sure what you are trying to do, but this line doesn't make sense:
Range("cells(2, m).value:cells(18,n).vlaue").Select
Correct way would be:
Range(cells(2, m),cells(18,n)).Select
Also m = 0 until the code comes to the line m = m +1.
As long as m = 0, the range Cells(2, m) is invalid as Colum 0 doesn't exist.
If you want to select the 18 column to the right of your used range for rows 2 to 18, then a loop doesn't seem to be the most effective way.
Try something like:
Dim lCol as integer
lCol = cells(2,columns.count).end(xltoleft).column +1
range(cells(2,lcol),cells(18,lcol+18)).select
Hopefully this is helpful to you.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Not exactly sure what you are trying to do, but this line doesn't make sense:
Range("cells(2, m).value:cells(18,n).vlaue").Select
Correct way would be:
Range(cells(2, m),cells(18,n)).Select
Also m = 0 until the code comes to the line m = m +1.
As long as m = 0, the range Cells(2, m) is invalid as Colum 0 doesn't exist.
If you want to select the 18 column to the right of your used range for rows 2 to 18, then a loop doesn't seem to be the most effective way.
Try something like:
Dim lCol as integer
lCol = cells(2,columns.count).end(xltoleft).column +1
range(cells(2,lcol),cells(18,lcol+18)).select
Hopefully this is helpful to you.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
