In the following code below, I want to copy a number of items from
Worksheet "Items" to Worksheet "Rooms" based on the value of txtRoom.
What am I doing wrong when I set "listrange" in the select statement?
I get a "Method 'range' of object '_global' error"

Hi there, I’m still pretty much a novice at this so please be gentle!
I’ve been asked to automate the inputting into a stock file  so I set up a
very basic sheet first (The actual file has 7 inputted columns and will be
run from a userform):

I have a text file I'm imorting into Excel with each line of text in a
cell. Something like this:
Feb '08 0.0000 Nov '07 0.0000 Aug '07 0.0000 May '07 0.0000 Yr 1 avg :
0.4167

I have the following macro which I want to place in column V7 which adds the
totals in E7 and D7 divides by 8 and then multiplies by 52. I am able to
execute with just E but when I add in D I get error messages either compile
error or expecting end of statement. I will also need ...

Hello everyone:  Need some help.  I am not an Excel Person, but got
stuck with a project because I was off the day they took the vote on
who should do it.
So far I've been pretty lucky just recording marco's and then placing

I am trying to copy a textbox to another textbox in multiple sheets within
the workbook.  Below is what I use to copy to one additional worksheet, but
not multiple worksheets after the 2nd.  Can anyone help?  Thanks
Worksheets(2).Range("A1") = Worksheets(1).TextBox1.Value

I need a macro that can delete certain rows as follows:
If B(X)=B(X+1) AND C(X)=C(X+1) AND D(X) =0 THEN
      Delete row(X)
      Else do nothing

I have created a csv file to import into an external program, and regardless
of how many rows are populated, the other program attempts to import ALL
65,536 rows in the csv file. Is there something I can do, within Excel,
preferably programatically, to ensure that only rows with ...

I have the below code that I use to toggle a third-party macro from
"installed" to "uninstalled" and vice versa:
If AddIns("Hello World").installed = True Then AddIns("Hello
World").installed = False

I have a template which is to be distributed across various networks.  When
the template is launched I need to be able to get the filepath of the
original template to subsequently read an ini file.
In Word this is 'ActiveDocument.AttachedTemplate' but can anyone tell me how

Simplified this but 1st column contains the data and the second column
is emtpy. Below is what I would like the program to produce when run.
Basically, For every new series of data a 1 would go in the  2nd
column. Pretty easy right, well I also need the program to put a 2

Hello!,
I am using a named range (dynamic: with offset and counta, to include
additional rows automatically) as my chart source (Office 2007). But i
noticed that every time I run the chart it changes the source to the

I have the following: -BUT it doesn't sort Column R
'   determine total range for sorting
  Dim lr As Long, lc As Long '(in declarations)
lc = ActiveSheet.Cells.Find("*", [A1], , , xlByColumns, xlPrevious).Column

Hello all, I am trying to clear a row after it has been selected to be
copied to another worksheet. The code I have currently copies and
pastes well but I still have to manually highlight and "clear
contents" to remove it. I'm sure for you guys that this is probably so

Excel XP & Win XP
   How can I determine if a specific folder, say "C:\The Folder", exists?
I have an OP who will be sending some files, and the code to place the files
in that folder, to some people.  Thanks for your time.  Otto