Not your question?
Ask your question
View similar questions
Check out some similar questions!
VBA If Statement
[ 4 Answers ]
Ok. Here's my problem. I have a spreadsheet that I use which filters on 6 different filter criteria and copies the result set of each filter criteria to a separate worksheet. However, on occasion there are no results found for a given criteria. What I want to do is when no results are found...
Can VBA do this for me?
[ 7 Answers ]
Refer attachment; For sheet "SPPA" cell "D18" value to be recorded on sheet "HO plan" cell "T7", and this is where it gets nasty, as the date rolls over on the "SPPA" sheet cell "F1", so must the macro record the new value in the next cell for sheet "HO plan", ie: If "SPPA" sheet cell "F1"...
Can this be done using VBA?
[ 5 Answers ]
Ok - I have a spreadsheet that is exported from an application I use at work. It formats the data in a manner that makes it really difficult to manipulate but I think I've worked out a solution that gets me what I need; only it is very tedious. The data starts in row 16 of the sheet. There is...
VBA Issue
[ 2 Answers ]
Ok, so here's what I am trying to do. I am trying to use a variable sheet name as a Named Range in my procedure but it is not working. Here's the part of my code that is failing: ActiveWorkbook.Names.Add Name:=NameRange1, RefersToR1C1:= _ ...
VBA Question regarding Headers
[ 1 Answers ]
Ok, so here's my problem - I'm trying to customize a Header to be displayed in different workbooks. I want the Header to contain the name of the Worksheet as well as the current year. The header will read this way: Month of August 2010 For the purposes of my code, I have the following... View more questions Search
|