I use this function to set up the same raneg on multiple tabs is the same
work sheet
  =OFFSET(INDIRECT(Report!C$1&"!a1"),0,0,1000,100)
It works great Report!C$1 is the place where I woul just type the sheet I

Can you tell me how to solve the issue of not hiding the totally blank
rows that are part of the worksheet for formatting purposes, but do hide the
rows that have zeros in them based on formulas.  I added the
hiderows/showrows to VBE, but it removes all the zero and blank rows.

This is my first time to use this tool so I hope I don't sound like an
idiot. I really need some help so I guess I will try it
I  have a list of 158 accounts that I want to perform a financial
calculation on. The data needed for the calculation is in a table and I have

Column N is value - Column A is the result
here is the code:
   Range("A2").Select
   ActiveCell.FormulaR1C1 = _

just want to copy the Range from one Sheet to another one, values and
all formats, perfect would be even the column width. When I copy and
paste manually, all is working perfect, but not with VBA. Be aware
that there are joined cells in my sheet. Any hints?

I have a web query which imports data on a w/sheet range A1:I57,a part of
data which is invisible unless I scroll down.The query has 5 tables. Is it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what ...

Below is the macro that mostly works - the problem is that when it gets past
a total row height, it should skip five row and start recounting - but it
isn't.   What am i doing wrong?
Sub SetPages()

I am trying to come up with a way of looping through all B2 cells in all
sheets and comparing the value to the values in a variable range, such as
B2:B15, on a specific sheet named “Region”, and if there is a match, copy
paste the entire row (just one row) 2 lines below the match ...

I am trying to create a loop with variable sheet names and I am having
issues. The error I'm getting right now is "Duplicate declaration in
current scope." I declare all the sheet names as Strings because if I
don't I get "Compile Error: Sub or Function not defined"

I need a macro that will copy information from a specific range of cells
(A1:A3, for example) and paste that information into a selected range of
cells.  Here's the catch:  after new info is input and copied, I would like
for it to be pasted in the range of cells directly below ...

We just got the word - we will be "upgrading" to Office 2007 shortly.
I _live_ by my macros!  If they worked fine in XL 2000 and 2003, will
they still work in 2007?
I figure I need to make a backup of my Personal, .xla and .xlb files.

I need to copy and paste various cells within various tabs for various
worksheets to other worksheets. So, through the Record Macro feature it came
up with a bunch of code that records every click and step but I want to make
it more efficient. This is part of the code:

I encountered an error in a previously fine loop structure.  The loop
operated on each cell in a range:
  For Each rng In rngCells
The problem started after I passed a range object to it declared using the

Hi all, i am pulling a text file into excel and the one field, e-mails, has a
lot of spaces of variable size in it, is there a way i can delete these with
code ??
Any help would be greatly appreciated...

does anyone know how to make a combo box position itself close to the active
cell each time a cell is selected??
have tried a few ideas but they all seem to take forever to execute in VBA