> In the formatting expression, "H" means to display the Hour without
> leading "0"'s.
> since this isn't a TIME, I suspect you were trying to use this format
> statement
> as if it were similar to C++. It's not.
> How it
Can not use like that.
All I know is which column i need to use. I do not know how long is the sum
range and where to start.
That's why I have FBTFirstrow and FBTlastrow . I need to have sum formular
in the cell so i can verify the formula
On Thu, Jun 24, 2010 at 3:22 PM, saggi wrote:
> If you
f the formula is
> ='[Book1.xls]Sheet 2'!$A$3. Unticking edit directly in cell will mean
> you can't edit formula's in the cell, you have to do it in the formula
> bar.
>
> Cheers,
>
> Spud
>
> On Mar 22, 10:34 pm, Mark Kim wrote:
> > The pr
The problem is then I need a create hyperlink manually..
Then I need to create hundreds hyperlink..
Also, everytime I click the cell, it takes me to the reference cell, which I
don't want to. I want to go to the reference cell when I want to.
That's why I don't think Hyperlink is a solution.
Du
On Fri, Feb 26, 2010 at 4:44 PM, Ayush wrote:
> Hi Markkim,
>
> Would you please send the sample file containing this data?
>
> Best regards,
> Ayush Jain
>
> On Feb 26, 6:18 am, Markkim wrote:
> > Hi
> > I have been trying to make these but have failed. ^ ^;;
> > I’d like to create a macro
> >
Hi, Thanks for the code.
But I tried but it doesn’t seem to work as expected. Can I ask you this
please?
in the data sheet you uploaded, what I want is to select Dat1 to Data 7 and
remove blank rows. In my real data I work with, there are 6 rows between the
last transaction record and FBT detail
Sorry I didn't attach an file.
hm.. not sure how to attach a file.
Hope this is ok..
On Sun, Jan 17, 2010 at 7:50 AM, Mark Kim wrote:
> Hi Praveen
>
> Thanks Million!!! This is exactly what I was looking for..
>
> Thanks a lot !!!
>
>
> On Sun, Jan 17, 2010
Hi Praveen
Thanks Million!!! This is exactly what I was looking for..
Thanks a lot !!!
On Sun, Jan 17, 2010 at 1:35 AM, kvc praveen kumar wrote:
> Hi,
>
> Please find the attached file and let me know if this is what you are
> looking for. I used worksheet events to impement the same.
> Regards
