Hi Vabz
Thanksfor good work in sorting for me.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Cheers!!
ᐧ
On Sun, Jan 25, 2015 at 1:53 PM, sswcharlie swch...@gmail.com wrote:
Hi Vabz
Thanksfor good work in sorting for me.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect.
You have declared variable Range as Integer which is not correct..replace
that with Dim rng as Integer.
If you still get an error do send other part of code as well or entire
sheet..
ᐧ
On Sat, Jan 24, 2015 at 1:25 PM, sswcharlie swch...@gmail.com wrote:
Hi Vabz
Thanks for that. Tried that
Hi Vabz
Thanks for the WB it works great.
However when I incorporate code into my project VE comes up with error ,
see below, at the word 'range' . My code is:
Option Explicit
Private Sub CommandButton1_Click()
Dim ctl As Control
Dim Range As Integer
With
Hi Vabz
Thanks for that. Tried that but get 'Compile error, Expected Array' on
the word 'range' in the new code.
Have I got something wrong in the setup somewhere? There is not much
there to go wrong! Is Option Explicit a ouproblem?
Thankyou
Charles
On Thursday, January 22, 2015 at
try this code..replace your existing lines:
Intersect(Range(H:H),ActiveSheet.UsedRange
Offset(RowCount,0).Value=Me.RegAreaEnter.Value
with
Range(H65536).End(xlUp).Offset(1, 0).Value = Me.RegAreaEnter.Value
Cheers!!
ᐧ
On Sat, Jan 24, 2015 at 6:48 AM, sswcharlie swch...@gmail.com wrote:
Hi
check this .xls version..
Cheers!!
ᐧ
On Fri, Jan 23, 2015 at 1:28 PM, sswcharlie swch...@gmail.com wrote:
Hi Ashish
Thanks for your WB etc. My Excel2000 will not open. Are you able to
post .xls version which I can download.
Thankyou
Charlie Harris
On Thursday, January
Charles,
PFA for find last value in column.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
Hi Ashish
Thanks for your WB etc. My Excel2000 will not open. Are you able to
post .xls version which I can download.
Thankyou
Charlie Harris
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row-
Hi
Have checked and this is all the code I had.
What I want the code to do is to put the last number in a list in the text
box on user form.
Thanks for your help.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax'
10 matches
Mail list logo