Cheers!!
ᐧ
On Sun, Jan 25, 2015 at 1:53 PM, sswcharlie 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.
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
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 wrote:
> Hi Vabz
>
> Thanks for that. Tried that but get 'Compile
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 6
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 wrote:
> Hi Vabz
>
> Than
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 Worksheets("RegionalAreas").Ran
check this .xls version..
Cheers!!
ᐧ
On Fri, Jan 23, 2015 at 1:28 PM, sswcharlie 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, Janua
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
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 titles
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
