Re: Find & replace a value in an unknown cell location
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
You have replies at your thread in .excel.
mellowe wrote:
>
> Is there a function I can use to find a text string in a particular column -
> say in column (H) for string 'Mytotal' to be replaced by 'Subtotal' when the
> cell location of 'Mytotal' is unknown only the column is known? And also is
> there a function that can find a certain value in a column then delete the
> row below the found value? e.g in column (H) find 'Subtotal' then delete the
> row below the occurance of 'Subtotal'. Help is much appreciated with this one?
--
Dave Peterson
.
Relevant Pages
- Re: How to reference unsaved workbook in functions????
... you can build that string. ... MVP - Excel www.dicks-clicks.com ... Post all replies to the newsgroup. ...
(microsoft.public.excel.programming) - Re: Pad with leading zeros?
... MS MVP - Excel ... [please keep replies in the newsgroup - email address unmonitored] ... > zeros on the numeric value, up to a full string length of 3. ...
(microsoft.public.excel.programming) - Re: Need help with SeriesCollection Object Please !
... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
(microsoft.public.excel.programming) - Re: You have to put the URL of the webpage in the macro.
... I need your help to update Excel Data in Web Page. ... Function ZipPlusFour(sAdd1 As String, _ ... Dim sResult As String ... Take the html text and put it in a file called ...
(microsoft.public.excel.programming) - Re: Format Excel - Object required error
... tell excel to autofit the columns. ... Public Sub FormatXLReport(strPath As String, ... Dim blnExcelExists As Boolean ... Private Const SW_SHOWNORMAL = 1 ...
(microsoft.public.access.modulesdaovba) |
|
