I create daily reports with data linked from day to day. Many cells are
protectyed formulas.
I'd like to create a macro to copy the current report, creating the next
day's base report.

I am trying to have my VBA code open a workbook from a website however I
don't want to have to keep refering to the whole URL name every time I need
to call it or work with it in my code so I just want to assign a short name
variable to represent it and currently my code is ...

I want to identify the day of the week in my spreadsheet and have used the
formula
=IF(WEEKDAY(L2)=1,"SU",IF(WEEKDAY(L2)=2,"M",IF(WEEKDAY(L2)=3,"T",IF(WEEKDAY(L2)=4,"W",IF(WEEKDAY(L2)=5,"TH",IF(WEEKDAY(L2)=6,"F",IF(WEEKDAY(L2)=7,"SA","")))))))
where the L2 cell would have a date ...

How can I hide Row 5 when Cell B5 is blank, and likewise for all rows in the
table?  Tried pasting from another thread here into the VB macro page, and I
must have missed something in the process.
General layout:

Can any one suggest a way to loop through an Excel worksheet rows till
i see a null in the contents of the cell Here is sort of pseudo code.
Start
Worksheet("sheet").cell(row,col) <> ""

I am trying to correct a "script out of range" error in a macro, but I'm not
sure what it refers to.  Here's a copy of the macro, if anyone could tell me
what I'm looking for that would be great.  Thanks, J
Sub MoveRow2Data()

Hello,
I am trying to set up subroutine that will activate when a user
doubleclick on a cell in a named range on worksheet.
As usual, the help file is anything but. I had done somethig similar in

I am trying to speed up the repetitive tasks of editing a cell. My formula is
simply pulling the value from another file, (copy and paste value won't work
and is not dynamic). I need to copy this formula across eight columns but the
original has absolute valued to the first ...

Someone, anyone, please provide me some assistance.  I'm having issues
w/ an =AVERAGE formula.  I've got 9 employees and need to get the
running average QA score for the whole team throughout the year.
Maximum number of QA's in a month is 10 per person.  Each employee has

Hi, I have a sheet with the following structure
' A     B    C   <-- Columns
/START/
1

hi,
lets say i have some data in a sheet.  and column A is compared to column AB
to apply a conditional formatting based upon whether column A is less than or
greater than amount in column AB.  then I resort the data in column A only,

    Hi.. well i'm back again.. this glitch is more than I can figure out... The
macro seems to be putting the information in only "one" column...
the information that needs to be inserted is going down to the 5th row in
Column D and putting "all" of the information there, instead of ...

Ok I don't know what is up with this but this has to be the most strange
program bug ever. I have wrote a program in excel VBA that goes out to a
website grabs data then parses it and puts it into a spread sheet. I have
used an Array to store the data it gathered from the website ...

Hello, I need an average of last 6 scores discounting the lowest and the
highest.  I need to also discount blanks/zero for days the person does not
show. Thank you for your time and patience with me.

Can you dynamically set a comment size based on the amount of text it holds?
I see a way to set the size using comment.shape.height, etc. but is there
some sort of "autofit" similar to range.columns.autofit() ?
Thanks.