Je me casses les dents sur un problème VBA.
J'ai créé un programme vba dans excel pour gérer des commandes
J'ai dans un onglet un formulaire, une fois complété il est copié
sous un nouvel onglet qui se renomme automatiquement avec le numéro de

Okay.  So, at one point in time I used a spreadsheet that had a buttton built
into the spreadsheet that made all rows with no data in column e dissappear.  
I am an idiot but i need to do this to my order forms.  Then it had another
button that made it reappear.

I already searched this and found several macros, but they do not
work.
Normally when you have a lot of rows of data -  you can click the
scrollbar button and drag down to the bottom to see that last row of

I have a sheet with a column that is conditionally filtered, with this
filter =OR($T8-$S8>25000,$T8/$S8>120%). I want to copy the cells that
meet this criteria to a new sheet. I can't quite work out the script
for the criteria. Your help is appreciated. TIA

I have a spreadsheet that I have applied the Data autofilter. When you click
a filtered cell, a list of one of every group of entries in the column pops
up. Does anyone know of a way to have this list pasted into rows of the same
column below the existing data entries?

Help I am writing a Macro in excel an have a problem.
I need to check a Section of Cells for Values (O4:R4).
  If there is a Value continue.
  If NO Value then Delete Cells (A4:W4).

I need the Macro coding that will calculate cell(s) in another file.
Can it be done if this other file is also on the computer screen?
Can it be done if this other file is not also on the computer screen?
If either or both can be done,  what is the Macro codings?

This is my first post.
I don't seem to have the indirect function included in my library of
objects.  The following code gets me an error "Object doesn't support
this porperty or method".

I imported a 'contact list' db into an excel worksheet.
It has many areas needing fixing before I can eventually import the
info I need into an access db table.
The first one I want to address is the fact that the contacts (3 rows

Hey All,
How do I link specific column ranges from one spreadsheet (A11:[End of Data]
through F11:[End of Data]) to another spreadsheet where it automatically
refreshes data each time it's opened.

I'm importing multiple, linked tables from an access database. All the tables
are coming into Excel and showing as the correct field names, but half of my
records are missing. I'm expecting over 700 and there are only just over 300.
Hope this makes sense, i'm a newby!

I've writtena User Defined Function that yields #NAME? when I use it in a
spread sheet. Why is this?  The code for the function is below.
The code is in a module in PERSONAL.xls.  I have also tried it in a module
in the workbook where it is used. Same result.

I have a sheet of values in column A. In column B I have a number that
indicates how many times the value of A should be copied to the adjacent
cells.
A         B        C     D     E       F     G  

row 1 has either Section I or Section II in it
Row 2 has numbers
both rows run from A to BY
In BZ I need to sum all section I

Hi I've searched through group and haven't quite found an answer for my
use.
I have multiple individual text files, that contain simple text.
I want to import them into 1 workbook each as a seperate worksheet.Each