Lookup/Identify next number,Paste into cell
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
16 Mar 2010 à 06:50
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 18 Mar 2010 à 03:19
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 18 Mar 2010 à 03:19
Related:
- Lookup/Identify next number,Paste into cell
- Https //accounts.google.com/sign in/v1/lookup - Guide
- The system could not identify your location viber - Guide
- How to copy paste youtube link on android - Guide
- Midomi upload audio identify song - Guide
- Facebook com login identify ctx recover ✓ - Facebook Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Mar 2010 à 10:10
16 Mar 2010 à 10:10
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 7 February 2010
Status
Member
Last seen
15 April 2012
18 Mar 2010 à 03:19
18 Mar 2010 à 03:19
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