Programming

Autofill Formula
I am getting a "Method Range of Object Global Failed with this code. What am I doing wrong? Dim MyRangeA As Range Dim LastRowA As Long Range("J14").Select LastRowA = Cells(Cells.Rows.Count, "J").End(xlUp).Row Set MyRangeA = Range("J" & ActiveCell.Row & ":J" & LastRowA - 4) ActiveCell.FormulaR1C1 = "=MID(R... 24 Mar 2010 14:43

Conditional Format
Hi, I am creating a conditional format which is based on a value form another cell say: if value is less than: =If(r14=14,20,30) however can I set the cell to be relative rather than one cell? Thanks ... 24 Mar 2010 18:11

Named Range
I'm creating a template in which a user can copy & paste their records and format it a certain way w/a macro button. One portion of the macro should create a named range for all records that appear in column J, starting at J4. However, as you can see from my code the marco is always going to name whatever is ... 24 Mar 2010 15:52

This one is For all the accomplished MVPs.
Is there no way to fully protect a VBA project? I have come across many comments in the excel programming news group which say that it would take 30 seconds to un-protect a VBA project. What is the best way to make the opening up the VBA project as difficult as possible. I was expecting that 2007 Excel ve... 8 Apr 2010 11:05

Code to find all / next in a row of data
XL 2007 on XP Pro: I have a s/s with many names in cells along a row (in random order.) Some names may be the same. So I am trying to write a macro to "Find" the names that match one entered into a cell by a user. He should be presented with those that match and be able to select the one required. The active ... 24 Mar 2010 10:02

microsoft 2008
-- Selamat Datang Di Web Microsoft...!! Kunjungilah Web Ini. http://todymicrosoft.net ... 24 Mar 2010 05:30

senin - sabtu
saya ingin tahu cara pengunaan microsoft excel untuk membuat spesifikasi pada jaringan?.dan juga ingin mengetahui lebih dalam lagi tentang microsoft excel?. ... 24 Mar 2010 05:30

What VBA function returns cell 2 from which cell 1 gets its value?
This is a simple and possibly embarrassing question. In Excel 2002 SP3, cell 1 is on ProfitSheet and depends on cell 2, on a different sheet. Cell 1 has a UDF, so it looks like: "=MassageData(SalesSheet!$A$1)" Given that I know cell 1 at runtime, what VBA function returns cell 2? I have tried: Set Ce... 25 Mar 2010 06:53

Sheet and workbook code: All sheets should have row 1 to 5 of Shee
Your best solution is to copy rows 1 through 5 from Sheet1 into all other sheets and use Page Setup to repeat rows 1:5 on each sheet when it is printed. If the entries in rows 1:5 of Sheet1 change often and you need to have the same entries on all other sheets, then set up the entries on the other sheets to li... 24 Mar 2010 01:10

random selection of rows
I have a master list of all of our cases--there are approximately 20000 rows, each row representing a single case, and each row has 13 columns of data. I filtered the list, for example, to see all of the active cases for a case manager. Suppose that filter produces 117 cases (there are of course a different n... 25 Mar 2010 17:28