Dear All,
Hope you all are doing well !
I need your assistance to sort out my problem. I need to extract 6 & 7 Digit
number from the string.
Example :
I. C, Rajendra Palace, New Delhi 110053
II. C, 301 Rajendra Palace, 110053 New Delhi
III. C, Rajendra Palace, 110 053 New Delhi
*Result : *
I.
Dear member
I need to white loop for find excel in folder at booked .
and find already open the program this .
Anirut.K
fujikura thai .
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
A coworker sent me a workbook with a macro that runs fine on my
laptop. On her laptop, the macro runs and at a random point within
the macro, it pauses, as if that spot in the code has a break point.
Hitting run restores the macro to running and it completes normally.
Has anyone experienced with
Hi Ashish,
Sorry I can't share the document.
On Sep 21, 11:36 pm, ashish koul wrote:
> Hi Clint
>
> Can you attach the sample file
>
>
>
>
>
>
>
>
>
> On Wed, Sep 21, 2011 at 11:08 PM, Clint wrote:
> > This one has been driving me crazy. VBA seems to have a problem
> > removing calculated fiel
Once i faced some issue. these happen because of comments updated in
previous excel sheer from where data was copied..
i also not able hide columns. Select worksheet and remove comments (excel
2007 steps)
Removing Comments from All Cells
1.
Open the sheet with the comments to be deleted
HI Swapnil,
Thnxs for the code...along with date..i also need to convert time from
textplease refer coloum O to AA in excel.
Kindly help me with the code...please
On Thu, Oct 6, 2011 at 11:36 AM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:
> Hi,
>
> Further to Sam's solution,
Just an additional check.
Verify if there are some objects lying at the boarder of the
worksheet. See the attachment for better understanding.
Feel free to get back in case of any queries.
Regards,
DILIPandey
On 10/6/11, Sam Mathai Chacko wrote:
> I wasn't able to see the picture earlier. Stra
Hi Craig,
Please find the solution attached as a sample. It has the same idea
as suggested by Sam. Thanks.
Feel free to get back in case of any queries.
Regards,
DILIPandey
On 10/6/11, Craig Brandt wrote:
> Conditional Formatting Highlight of Changed Cells
> I have a large spreadsheet where
Good job Rajan... !!
Few months back, I also had one software viz Bad Copy Pro which I used
to recover corrupted fils, which I lost - not sure if you also have
such kind of software.
Thanks,
DILIPandey
On 10/6/11, rajan verma wrote:
> hi
> See the attached Workbook,i think some Content of thi
Sub create_ppts()
Dim slidecount As Integer
Dim slide As slide, PPSlide As slide
Dim shp As Shape
Dim ppres As Presentation, pp As Presentation
Dim filepath As String
Dim a()
filepath = "c:\"
a = Array("XA", "XB")
Set pp = ActivePresentation
For i = LBound(a) To UBound(a)
Thanks very much for your help, that's exactly what i need.
Thanks again
On Thu, Oct 6, 2011 at 3:56 AM, ChilExcel wrote:
> Please see attachment
>
> Chilexcel
>
>
> 2011/10/4 Ahmed Emam
>
>> Hi all members,
>>
>> I need an Excel sheet that contains check list for about 20 items , and
>> that w
Hi Suman
u can try below UDF also
'Below User Define Function extract Number from string
Function ExtractNumber(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
Select Case Asc(Mid(rng.Value, i, 1))
Case 0 To 64, 123 To 197
ExtractNumber = ExtractNumber & Mid(rng.Value, i, 1)
End Select
Next
Thank you very much for your help!!!
The input data comes from a printed pdf file created from our
operational software package. I convert it to an excel file and the
subtotals come along for the ride. I needed to reduce the file size in
order to email the spreadsheet so I removed much of the
Dear Suman,
Please try below function and see attached sheet
Through Excel
B1=MID(B3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B3&"0,1,2,3,4,5,6,7,8,9")),LEN(B3))
Press ctrl+shift+Enter
C1==LEFT(A3,LEN(A3)-LEN(B3))
Through VBA
Function extractonlytxt(txt)
Dim txt1 As String
txt1 =
I decided to go with Sam's suggestion, it suites me more. I would like
to thank you both on such prompt help.
Regards,
seba
On 5 okt., 19:37, Sam Mathai Chacko wrote:
> If you need prompts, and if the files are in different folders, then
> Application.GetOpenFileName (my earlier code uses it) ca
Dear Craig,
Please Try
Review-Track Change..
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt wrote:
> Conditional Formatting Highlight of Changed Cells
> I have a large spreadsheet where users occasionally will overwrite the
> builtin formula with a value. I would like Conditional Formatting to
>
Hi Craig
you can use Track changes option from excel
http://office.microsoft.com/en-us/excel-help/about-tracking-changes-HP005230064.aspx
HTH
Mahesh
On Thu, Oct 6, 2011 at 1:24 PM, Sam Mathai Chacko wrote:
> Goto VBE, insert a new module in your workbook vba project, and add this
> function
>
Goto VBE, insert a new module in your workbook vba project, and add this
function
Function HASFORMULA(rngCell As Range) As Boolean
HASFORMULA = rngCell.HASFORMULA
End Function
In your conditional format rule, use =HASFORMULA(A1)
Regards,
Sam
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt
Hi Shaneallen,
FYI. Lot of online file storage websites are available. Please upload your
file into http://box.net and send the file link to here. Everyone can
download that 10mb file.
Rgds,
MARIES.
On Thu, Oct 6, 2011 at 10:35 AM, shaneallen wrote:
> Dear Don have forwarded the file to you
>
Conditional Formatting Highlight of Changed Cells
I have a large spreadsheet where users occasionally will overwrite the
builtin formula with a value. I would like Conditional Formatting to
highlight these cells that were changed from a formula to a numeric
value. My first shot in Cell “A1” was a c
20 matches
Mail list logo
