find vba

Hi, I am trying to use the following code on a specific tab of a workbook I am working. The generic code works on other tabs just not on the one referred to in the below code: 'Selects Comparison To Fcst Sheets("Comparison To Fcst").Activate Range("D7").Select 'Searches through...

Here is the code I tried. but it stuck in finding the cell. (Set RangeObj = Cells.find) Please check the following code:Sub CopyFromFile()Dim MyFile As StringDim erowDim Filepath As StringFilepath = "C:\Users\Nazmul Hossain Akash\Desktop\Play Excel\Final\"MyFile = Dir(Filepath)Do While...

Hi guys, Another problem from me, but this time it's VBA based. I'm trying to find data from my clipboard in another spreadsheet. At the moment it's a laborious process of copying, changing windows, findings, etc. This is the code I'm trying out, but i dont understand why it's producing an...

Hi Can someone please help me write a VBA code for the following case? I have formula in Column C which returns either FALSE or TRUE. I want macro to find All FALSE and select the results. please help

I am trying to develop a macro to build formulas on a second sheet from data in cells of the first sheet. There are header rows written into merged cells which I need to read and save their addresses. By making a range that is wide enough to span the widths of the merged cells, I can find the...