Search results for query: *

Thank you very much. I am trying to change the content in cell A3. That is why I have to select it and then write in the macro this>> ActiveCell.Formula = "2-18-05" After that I need the name to be changed, and that is why I need >> Sheets(1).Name = "2-18" Is there a way to enter as...

I need to perform certain formatting to a series of open files. I came up with a small macro, that as I go along will expand into further formatting. My two biggest questions are: 1.- I am needing to specify in the macro manually before running it to variables to be changed in the worksheet...

I have two macros. In the first certains cells in the worksheet contain the files that I need to open and copy information from them once I have inserted in a specific cell the location I need the information from. This needs to be repeated for each sheet in my workbook. I need to be able to...

Bowers, Is there a way that it will loop itself until it takes care of all the duplicates. Sub DeleteDupes() Dim c As Range, SearchRange As Range Set SearchRange = Range([F2], [F2].End(xlDown)) On Error Resume Next For Each c In SearchRange If c = c.Offset(-1, 0) Then c.EntireRow.Delete...

Thanks. It works beatifully!

I am trying to build a application in Excel to place an active reading into the months in order to later on only pick values that have an active forms. For some reason is not stoping at the cell carrying the date selected in the cell. The values in the cell is selected from a dropbox (data...

Thanks xlbo However it know returns an error 1004. Activate method of range class failed What could be possible cause?

I have been trying to find out what error is in this code, but no luck whatsoever. I keep getting RUN_TIME Error '1004' Select Method of Range Class Failed Set book = Workbooks.Open("C\FileName.xls With book.Sheets(2).Range("F1") .AutoFilter .AutoFilter Field:=7...

Nevermind....Thanks a mil!!!

Let's see

CLFlava... What do you mean by surround it, because I tried to place it [code] It doesn't work [\code]

jcrater! It works marvelously... I have a question though. What does it do the [code][\code] For iRow=intLastRow to StartRow Step -3 [code][\code] My logic tells me that when it finishes up with the first set of contanetation it is only backing 2 rows, therefore including the very last that...

This is awesome. Thanks a lot. I am learning a lot from everybody. I hope someday to contribute as much as you do!!

It was giving me an error with [.CurrentRegion.Select .Copy End With] Therefore I took the select out. But then errors out again in [ Windows("ME Performance Report Plants.xls").Range("H7").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False...

Thanks. cLFlaVA... Could prompt this message box in the first macro that is ran in order for the user to select the date first in the O4 cell? Below is a sample of the macro that fires up first to run the report. Feel free to make any correction necessary to run this more effectively...

The macro below creates the formulas in the rows available and then fills the cell below with the same formulas to the exact range of cells specified when recording. However I have other applications or worksheets where the number of rows could be variables. How do I make run on variable...

I am trying to create an excel report that will be gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...

I am not familiar with error trapping on valid input, because the user needs to select month from a dropbox and the rest of the procedures is automatic. The below is the first macro to be ran, and it will open another file in the server and update the information in my sheet. However the file...

I am trying to create an excel report that will be gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...

I am trying to create an excel report that will gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...