You cannot post messages because only members can post, and you are not currently a member.
Description:
This Group is dedicated to unleash the POWER of MS EXCEL & VBA MACROS,one of the best Programming ever created for Mankind.
It is 100% resistant to spam, serving over 6000 worldwide members. You can win prizes by submitting tips and tricks in the community. Experts including MVPs are active here.
|
|
|
cell selection
|
| |
In a macro, I would like to be able to select a group of contiguous
cells containing information, where I know the location of the first
cell but not the location of the last cell in the group. I also know
that the only cells in the column containing information are in the
group of cells to be selected. Is there a neat way to do this?... more »
|
|
|
Pasting a block of cells/object
|
| |
Hi,
I would like to know if this is possible in excel 2007 and any
pointers where to look.
- I have a block of cells (like a sort of table) which I want to
define as one object (is there any way I can do this)
- Is it possible somehow with a single function to copy this object
(or block of cells) say 30 times? instead of copy/paste each one?... more »
|
|
|
procdure to limit the printing to fix number of times
|
| |
dear gurus, say i have a worksheet, but i want to limit the printing of this worksheet to 10 times only. is it possible? any vba idea. most probably this is a worksheet print event? im new to macro. thanks for understanding. dellosa
|
|
|
Managing TELNET Session with Macro
|
| |
Hi Excel-Experts ! I wish to build a Macro which does some routine work on UnixBoxes via launching Telnet. I can successfully launch Telnet Session using SHELL command but further if I wish to type in using Macro I am not... Please anyone can share an idea to make it work? cheers Kamal
|
|
|
InputBox
|
| |
I need to be able to insert text into a cell using the “inputbox”
function linked to a button. The macro below allows me to input the
text, but getting it to go somewhere eludes me. I realize that
"Copy.Name" doesn't work but how do i direct the entered text to a
cell? Suggestions appreciated.... more »
|
|
|
Need 1 pivot table for 7 & 8 Sheet
|
| |
Hi All, I have 7-8 diff. workbook containing around 1500 line items in each sheet. i want to make a single pivot table form all the sheet. is it possible? If Yes, please provide the example also.....
|
|
|
lookuphelp
|
| |
Dear Dave and Dilip, The solution you suggested where out of the box. Its genuis, While I solved it by naming uniquely each rows, and implement "ifs" to lookup on it based on criteria. Although returning the correct values, I discarded my long formula and adapted your great ideas. Its simply magic. Dellosa... more »
|
|
|
|
