I currently have Sheet2 active in this example:
Sub TestIt()
   Dim Line as Integer
   Line = 8

Is there a way that I can search for a string without using lookup, I don't
want t o sort any columns or rows.
This is what I would like to do:
Search for if (Sheet1!b2= a2) and (sheet1!c2=b2) then place the string from

hi, I have a spreadsheet with 20 columns but the report which supplies this
spreadsheet will supply less than the 20 coumns of information.  I want to
graph this data but I cannot figure out how to hide the blank columns.
Can anyone help?

As an ACT! 2005 Premium for Workgroups User, I export Opportunity records to
Excel.  Exports to Excel 2000 work fine, but if the user has Excel 2003, we
get the error "Exception from HRESULT: 0x800A03EC".    Has anyone found a
workaround for getting Excel 2003 to work?  Thanks.

morning all (or afternoon / evening depending on when you read this)
im working on creating a little activity counting tool for a team we have
that has no idea how many times they do something and dont want to use paper
to count

I'm trying to create a script which adds a new sheet with datas from other
sheets.
Some things work now but I have still an error and I realldy don't
understand why.

I have produced some event code which altomatically simulates clicking the
drop arrow box and zooms the display for ease of reading whenever a cell
referring to a validation list is selected. I want the zoom to return to its
previous lower setting once a selection has been made ...

i have a folder containing many folders
i want to send particular folder to a particular branch of my office
we are connected through lease line and i am allowed to ping the server of
the office

I have drawn a calender on my excel spreadsheet using activeX.
I have a sheet for each month, what I am trying to achive is draw a calender
on each of the sheets, lets say it is the January sheet that I am looking at.
I only want it to show January on the calender and not be able ...

I am using code to log in our intranet
That works perfectly, but trouble is: I must insert my password manually.
How can I use vba to insert password automaticcaly.
I use code below

I have a macro that works all the way up until it reaches the following code.
Basically, I am trying to create 26 Commandbuttons via a macro (works) and
write the code within the macro for each button to access its respective
sheet.

Is there any other way of getting the selected range on the individual
sheets of workbook after the workbook is opened.  The reason is
workbook/worksheet must be storing this last selected ranges. So whenever we
switch between the sheets the last selected ranges is shown. So from ...

I  am looking for macro that will remove data from rows with zero value and
hide that rows.
For example, there is 3 columns, some rows contains data like this:
5962-9090801MVA     abc CONVERTER I.C.           0.00

Good evening, all,
I'm writing a worksheet_change macr that will set a value in column V of the
target row if a change is made in any of the columns B to U.
So, if I make a change in any cell from A15 to U15, I want to select/goto

I'm tasked with running an employee contest using Excel.  I wrote code at
home using Excel 2000 and it works fine.  At work, using 2003, I run into
problems.  In the spreadsheet there are 3 sheets that must not be changed (a
scoring summary, a master, and a dummy entry form that ...