Hi,
Further to Sam's solution, here is the complete code
Sub converToDate()
Dim sht As Worksheet
Dim rng As Range
Dim r1 As Integer, r2 As Integer
For Each sht In ThisWorkbook.Sheets
Set rng = sht.Range(A1)
Do While UCase(Trim(rng.Value)) DATE
Set rng
Dear Don have forwarded the file to you
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
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
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 shanealle...@gmail.com wrote:
Dear Don have
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 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 samde...@gmail.comwrote:
Goto VBE, insert a new module in your workbook vba project, and add
Dear Craig,
Please Try
Review-Track Change..
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt craigbran...@gmail.com 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
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 samde...@gmail.com wrote:
If you need prompts, and if the files are in different folders, then
Application.GetOpenFileName (my earlier
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},B30,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 =
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
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
Thanks very much for your help, that's exactly what i need.
Thanks again
On Thu, Oct 6, 2011 at 3:56 AM, ChilExcel chilexcel...@gmail.com wrote:
Please see attachment
Chilexcel
2011/10/4 Ahmed Emam aaa222e...@gmail.com
Hi all members,
I need an Excel sheet that contains check list for
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)
Set
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 rajanverma1...@gmail.com wrote:
hi
See the attached Workbook,i
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 craigbran...@gmail.com wrote:
Conditional Formatting Highlight of Changed Cells
I have a
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 samde...@gmail.com wrote:
I wasn't able to see the
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, here
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 Ashish,
Sorry I can't share the document.
On Sep 21, 11:36 pm, ashish koul koul.ash...@gmail.com wrote:
Hi Clint
Can you attach the sample file
On Wed, Sep 21, 2011 at 11:08 PM, Clint clinthjack...@gmail.com wrote:
This one has been driving me crazy. VBA seems to have a
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
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
21 matches
Mail list logo