Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Group info
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 2569  Older »

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 »
By Tommy  - 10:03am - 2 new of 2 messages    

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 »
By Chris  - Nov 10 - 1 new of 1 message    

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
By OSAVentures Calamba  - Nov 9 - 2 new of 2 messages    

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
By kamal shah  - Nov 9 - 1 new of 1 message    

Problem in Excel File attached 
  Dear Sir/Madam Pl see the file attached... Regards
By Jitender  - Nov 9 - 1 new of 1 message    

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 »
By Tommy  - Nov 9 - 3 new of 3 messages    

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.....
By Mahesh  - Nov 8 - 2 new of 2 messages    

vba to close workbook if last row with data = 10 
  dear gurus, i need to close a workbook if last row with data =10, Any VBA suggestion please? dellosa
By OSAVentures Calamba  - Nov 8 - 7 new of 7 messages    

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 »
By OSAVentures Calamba  - Nov 8 - 4 new of 4 messages    

Userform - user prompted for path of image which will be displayed in the workbook along with the other data. 
  or user prompted for whatever gets the job done...I am just assuming that would be the way to get it done. I have created my first userform to input data into my worksheet. I have 8 fields which populate my worksheet. On my userform I have an 'Add Data' button which works like a charm via a tutorial from... more »
By ellie  - Nov 8 - 1 new of 1 message    

1 - 10 of 2569   « Newer | Older »

XML       Send email to this group: excel-macros@googlegroups.com
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google