I have a spreadsheet with columns A through AD and have about 1000 rows on
my report. I need to run the report every month and send an email to anyone
that has a greater than or equal to 6 in Column "W". If column "W" is
greater than or equal to 6, then click a "send emails" button with an
at
Hi
When clicking a hyperlink, I want to know the address for the cell that
holds the hyperlink (internal to another sheet in the workbook)? When using
the follow_hyperlink event I can get the address for followed link, but not
the address from which I jumped.
Regards¨
Kim
--
Are you =EXP
Hi all,
I have a spreadsheet with thousands of rows and columns of text that
I'd like to translate into Greek.
Can anyone tell me how I might do that using VBA with some free
service or API online?
Many thanks in advance.
Kim
--
FORUM RULES (986+ members already BANNED for violation)
1
Thanks :)
Mvh
Kim Pedersen
Strand Vinduspuss
Tlf. +47 934 60 815
2011/9/24 dguillett1
> See Attached
>
> *From:* Urghhh
> *Sent:* Friday, September 23, 2011 2:33 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ When do my subscribe
uture reference.
Thanks guys.
Kim
On Jan 7, 1:32 am, Paul Schreiner wrote:
> Do you care if it is done with a macro?
>
> Option Explicit
> Public Dict_Vals
> Sub CheckVals()
> Dim KeyVals, R, MaxVal, MaxCnt, RowCnt
> Set Dict_Vals = CreateObject("Scripting.D
Thanks so much Ashish but the problem is in the temporary column. I
really need to do it in one cell only without introducing any new
data.
Any idea on how I can achieve that?
Again, thanks for your help.
Kim
On Jan 6, 4:07 pm, ashish koul wrote:
> check the attachment see if it he
quent occurrance outright.
I've tried using the mode command but it returns the first of the
most
frequent occurances but I want the highest of the most frequent
occurrances.
Any help would be greatly appreciated.
T
> 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
I want it to download a file like...
www.testsite.com\test.txt
to a spot on my hard drive like...
c:\temp\
without inputs or prompts or navigating to save location.
Can anyone help please? In all my testing, I have to navigate to
where I want the file to go which doesn't suit.
T
16 matches
Mail list logo
