Hi, Because "?" is a special character set in computer, if you want to find
it you must prefix it with tilde in the find. ( ~?)
http://support.microsoft.com/kb/214138
---
On Fri, May 7, 2010 at 3:05 PM, rf1234 rf1234 wrote:
> Dear All,
> Last time 1 of my friend come to me and ask that he is
Thank you Dave,
The code you suggested worked fine. Although i discovered that the user can
still open the file with macro disabled and change the cell content, save
and reopen it. now I wish when the workbook is open, it checks the value of
sheet1(D3) if equal to "BRIDGESTONE COMPANY INC." if ye
Dear group,
i try to catch the user's action via worksheet change event. My worksheet
has a value at cell D6 that i would like to remain constant and if that
value is change by user the workbook is closed.
My problem now is, even if this values are unchanged but if any other range
of cell is del
Hello Sundarvelan,
I suggest you try first the subtotal function of excel. On the menu click
on data then sub total, follow as prompted. It should give you what you
need.
On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need a macro to sort the below excel by client a
*Dear Group,*
I attached a sample worksheet which i used to extract data from it. This
worksheet is part of a large workbook.
This worksheet is used to dump values resulting from a formula calculated
from another worksheet in the same workbook.
I copy the entire range of the worksheet with formul
For I = 1 To rCnt
> If UCase(Sheet1.Cells(I, "A").Value) = inx Then
> RecRow = I
> Exit For
> End If
> Next I
> If (RecRow > 0) Then
> Sheet1.Cells(RecRow, "F") = "P"
> Else
>
Dear Group,
I'm trying to extract a data from another workbook to another workbook. I
created this macro but it gives me an OUT of range error.
Please help.
Sub Bankreport()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Set rd = Workbooks("C
gt;
> there isn't a Worksheet_afterPrint macro (sorry)
>
> but in this case, you can cause the "P" to be placed before printing.
> Also, you'd want to use a sheetchange event to clear the "P" when anything
> is changed.
>
> let me know if you need additional help
Dear Group,
I have a worksheet (sheet2) that I always print. Many of the information
from this printed worksheet is coming from record located at sheet1. Column
A in sheet1 contains the codes which I input in sheet2.range(b9) as a
criteria to extract data from sheet 1.
I would like that after pr
