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
Hi
Try turning off display alerts & screen updating, also change file format
to .xlsb so as to reduce file size..
Without going thru ur machine configuration & environment cant suggest
exact solution..
Cheers!!
ᐧ
On Sat, Jan 24, 2015 at 9:35 AM, satyas wrote:
> Hi Guys,
>
> Recently I start t
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
if you want to specify range address along withh activesheet property then
you got to use activesheet.cells(r,c) syntax
since you are using activesheet.range which doesnt support you are getting
an error..
ᐧ
On Sat, Jan 24, 2015 at 12:13 AM, StephenB wrote:
> I found the answer after much g
Hi Guys,
Recently I start to work on my client project where I am working on big
database problem I am facing is when I save any file its take too much time and
I have a number of such files.
My concern is is there any way to save such time or any thing like encryption
so that I can save the
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
Hi Vabz and all
Works very well. Great work.
Thankyou
Charles
On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote:
>
> HI
>
> Have cells that have had serial numbers entered (up to 50 serial numbers)
> each separated by a comma.
> Is there a VBA argument that can take the
Data copied perfectly as my requirement but not drag needed field as
described in previous mail, I using loop for it but still not success, pls
try to edit my code for it.
Thanks.
On 23-Jan-2015 7:04 PM, "Vaibhav Joshi" wrote:
> Dear Ashish Bhalara,
>
> Is it resolved?
> ᐧ
>
> On Sat, Jan 17, 201
I found the answer after much googling. I needed to remove "ActiveSheet".
myRange.RemoveDuplicates Columns:=1, Header:= _
xlNo
I'm not sure why but ...
On Friday, January 23, 2015 at 12:01:39 PM UTC-6, StephenB wrote:
>
>
>
> Hello all. First post.
>
> I'm not sure why the commented out
Hello all. First post.
I'm not sure why the commented out way of specifying a range works while
using myRange fails with a "run time error '438': Object doesn't support
this property or method". I cannot call out the specific location because
it will vary.
Sub testRemoveDuplicates()
Dim
*Hello Associate,*
*I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for **Siebel Developer**. Charlotte, NC **. Please find below
the job description for the same and revert back to me with your consultant
updated profile and contact details at the earliest.
*Hi**,*
*Hope you are doing great!!*
* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com
and I will get back as soon as possible.*
Hi
This is Shyam
Paul,
My sample data is attached. I tried your sample. This works for fine. Can
you possibly adapt what you have in your spreadsheet into mine ? If
possible also exclude the filter box. Entering from the top line for me is
perfect.
Thanks,
On Thursday, 22 January 2015 12:15:30 UTC-5, Bill
Dear Ashish Bhalara,
Is it resolved?
ᐧ
On Sat, Jan 17, 2015 at 8:41 AM, Ashish Bhalara
wrote:
> Thanks to reply Mr.Ashish Kumar, but my requirement in sheet is little
> different than write same data to another sheet.
> In my query sheet, the account entry in fields of Group, Account Ledgers,
>
Great!!
ᐧ
On Tue, Jan 20, 2015 at 6:34 PM, sach so wrote:
> Dear Vabz,
>
> Thanks! It works as i required.
>
> Regards,
> Sachin
>
> On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:
>>
>> Sach,
>>
>> Amended code to suits your need..
>>
>> Cheers!!
>>
>> On Fri, Jan 16, 2015 at 5:
Hi Bluey
welcome..kindly post your query in new post with country name for which you
want to create share portfolio..
Cheers!!
ᐧ
On Tue, Jan 20, 2015 at 4:53 AM, Bluey wrote:
> Hi All
>
> My name is Ian and I am a retired contractor. My interests are my family,
> gardening and the stock marke
Hi Vaibhav Bhai,
Superb Solution, Formula working great!!
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, acc
hey
check this..
cheers!!
ᐧ
On Fri, Jan 23, 2015 at 8:01 AM, MLT wrote:
> Vabz, At the bottom of the attached sheet, I highlighted 3 examples and
> what the expected return values would be for each example. The coloring is
> meant to show which ranges the example criteria would refer to. Is
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
PFA this is with formula in one column..
ᐧ
On Fri, Jan 23, 2015 at 1:25 PM, sswcharlie wrote:
> Hi Everyone
>
> I am in a different time zone and later to respond. In New Zealand,
> already Friday evening.
>
> Thankyou for your comments and workbooks. I am using Excel 2000 .xls
> and the WB f
20 matches
Mail list logo
