Lookup/Identify next number,Paste into cell
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Mar 16, 2010 at 06:50 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Mar 18, 2010 at 03:19 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Mar 18, 2010 at 03:19 AM
Related:
- Lookup/Identify next number,Paste into cell
- The system could not identify your location viber - Guide
- Identify power supply connectors - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Discord invisible name copy and paste ✓ - Internet & Social Networks Forum
- Area code lookup - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 16, 2010 at 10:10 AM
Mar 16, 2010 at 10:10 AM
Where in column B will that value B ? Are you saying that you want to look for the value in the last used cell in B column and then increment it by 1 ? If that is the case
lastValue= sheets("Sheet1).cells(rows.count, "B").end(xluP).row
lastvalue = sheets("Sheet1).cells(lastvalue, "B").value
Just a suggestion
Set rNextCl = wsDatabase.Cells(65536, 1).End(xlUp).Offset(1, 0)
this is good for 2003, but you would be better off with
Set rNextCl = wsDatabase.Cells(rows.count, 1).End(xlUp).Offset(1, 0)
lastValue= sheets("Sheet1).cells(rows.count, "B").end(xluP).row
lastvalue = sheets("Sheet1).cells(lastvalue, "B").value
Just a suggestion
Set rNextCl = wsDatabase.Cells(65536, 1).End(xlUp).Offset(1, 0)
this is good for 2003, but you would be better off with
Set rNextCl = wsDatabase.Cells(rows.count, 1).End(xlUp).Offset(1, 0)
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Mar 18, 2010 at 03:19 AM
Mar 18, 2010 at 03:19 AM
TX rivisa1
I've used =MAX(OFFSET($B$2,0,0,MAX(IF(ISNUMBER(B:B),ROW(B:B)-3,0)),1)))+3 CTRL+SHIFT+ENTER but will also try out yours.
TX G
I've used =MAX(OFFSET($B$2,0,0,MAX(IF(ISNUMBER(B:B),ROW(B:B)-3,0)),1)))+3 CTRL+SHIFT+ENTER but will also try out yours.
TX G