Programming

Protection Issue
I had a spreadsheet that someone else created that was protected. I don't remember exactly what I did but I copied the text and now I wish to protect just parts of it. The parts I wish to allow users to edit are working fine, but some of the rest of the sheet, which SHOULD be protected, are not protected. Do... 22 Jul 2008 11:39

reference cells related to the current cell
In a function, how do I reference values in cells offset from the current cell? For example, I want to concatenate the text in the cells in the two rows above the cell with the function call. Note that the cell containing the function is not necessarily the active cell, so I can't use Activecell to determine it... 23 Jul 2008 18:28

Excel 2007 chart question
I'm using the following code to set up my series for a 2-axis column / line chart. The first series is for the columns, and the second is for the line. I am able to set the line and marker colors for the second series, but I can't figure out how to set the color for the columns of the first series. You'll se... 21 Jul 2008 16:10

Application.Intersect
Why doesn't this work? Straight from the microsoft site, or the help files for Application.Intersect Worksheets("Sheet1").Activate Set isect = Application.Intersect(Range("rg1"), Range("rg2")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else isect.Select End If I opened a new workb... 21 Jul 2008 17:12

Trouble with an Array!!!
Does anyone know the maximum items you can have in an array? I have 25. When i enter any more i get "Compile error: Expected: expression". Or does anyone know a way around this. I'm trying to write code that will lock and unlock all sheets in a workbook. I have approx 10 more sheets to enter. See code below... "... 22 Jul 2008 11:39

Assign a single variable to an Array filled with same data typ
You have to declare the array as variant, even though all the arguments in the array have the same data type ( in my case Single)? -- Cheers, Ryan "Rick Rothstein (MVP - VB)" wrote: First off, the Array function returns an array and, in VB, arrays can only be assigned to other arrays if those other ... 21 Jul 2008 16:10

Pivot table refresh problem
Hi! I use a macro to modify a pivot table. This line return an errror. ActiveSheet.PivotTables("PivotTable1").PivotFields("Name").CurrentPage = "ABC" The field "ABC" is include in the "Name" column but in the pivot table, I cannot select it. If I go to the field parameter and click to show item without data, "... 21 Jul 2008 18:13

Find A value in a column and count the rows
I am not making this up I have been asked to do the following: Create in VBA such that the code finds a specified date in Column A and then counts the Number of rows to it and then plugs that number into an Hlookup. So then the Hlookup goes to that row and gets the appropriate value. so far i have the following... 22 Jul 2008 06:31

Need a Macro to create a Pivot where fields may change
I recently found out that I could host an Excel spreadsheet on the web and have filters set by each user. The filters are named by the user and then saved on their PC in the hkey_local_machine directory by some vb code so they do nt need admin rights. This way every time the user comes back to the public file t... 21 Jul 2008 15:08

how do i use a macro
I am looking for a macro that will run through a selected range of cells that will stop at each cell and wait for a keyboard button to be pressed, and depending on the button pressed will do different types of formatting. Can anyone help. I don't want this to work with a Dialog box or anything, I want it to w... 22 Jul 2008 09:35