AutoFilter Cut/Copy not working with Name Range
Sun, 7 Sep 2008 07:55:02 +1000
G'day everyone
For the life of me, I have no idea why this doesn't work properly.
All I get returning is the first record
I know this workes when I specify the Criteria1="081001", but when I use the
same value via SIDLook Name Range
Sub Search_Copy_Student()
Dim SourceSheet As Worksheet
Dim ...
|
IF function
Sat, 6 Sep 2008 09:55:03 -0700
If the cell I am referencing is between 1 and 10 I want my value to be CellA1
X1
If the cell I am referencing is between 11 and 20 I want my value to be
CellA1 X2
I need to continue this process up to "between 71 and 80"
How would I write this IF function?
Thank you for your help. ...
|
Script Not working
Sat, 6 Sep 2008 07:31:04 -0700 (PDT)
hi
Private Sub Worksheet_SelectionChange(ByVal Target _
As Excel.Range)
Cells.Interior.ColorIndex = xlNone
With ActiveCell
.EntireRow.Interior.ColorIndex = 40
.EntireColumn.Interior.ColorIndex = 36
End With
End Sub
the above script works only single worksheet not all workbo ...
|
countif criteria sg
Sat, 6 Sep 2008 06:56:00 -0700
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used
=countif(B:B,">=12 and <=29") but it did not work. =countif(B:B,">=12,<=29")
also did not work. what is the correct syntax for the criteria in the
formula?
t ...
|
Why doesn't the alignment dialog box come up like the book shows?
Sat, 6 Sep 2008 06:30:01 -0700
I am taking an online course in Computer Applications, and working with Excel
2007, as that is what is required. They are instructing us to click on the
alignment box and choose the 45 degree orientation, but I can't get the box
to come up. The Font dialog box comes up, as do the styles and other boxes,
bu ...
|
Print 100 Sheets
Sat, 6 Sep 2008 04:15:00 -0700
I have a workbook with almost 150 sheets. and i want to take the print of all
sheets. Is it possible to give a single command to take all the print. Or its
a manually job, to give the print one by one.
Thanx in Advance.
Hardeep kanwar ...
|
Sorting in locked sheets
Fri, 5 Sep 2008 23:26:00 -0700
I need to be able to sort (A-Z, Z-A) in a sheet some of the cells in which
have been locked. Is there a way?
--
Ken Curtis ...
|
|
|
Auto formatting
Fri, 5 Sep 2008 23:03:01 -0700
How do I assign a color to the highest value in a "Total" column so it will
stand out and also so it will remain on the worksheet?
...
|
Adding up the number of times a month is in a column
Fri, 5 Sep 2008 22:10:01 -0700
I have two colums, of which column B has months and dates. Sometimes the
date can be up to three times added, or not at all. I can't figure out a
formula to show me how many times Mar was added (12 in the below case) and
Apr was added (6 in the below case).
Number of update Date
1 1-Mar
2 1-Mar
3 1-Mar ...
|
Rank then sort then pastelink
Fri, 5 Sep 2008 22:03:01 -0700
I have 9 topics (ColumnA) with a tallied numerical answer(ColumnB) in Excel.
I have used the RANK function in Excel to Rank numerical responses from 1 to
9 in Column C. After that I need to sort them by the rank to be displayed
with the Rank Number and Topic name in Column D only to then have it
paste-li ...
|
