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.
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
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
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
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
