No announcements
Found 2735729 threads
-
0 VotesExcel VBA code for ordering worksheets using sheet code name
integer of code name and than ordering sheets in ascending order. For e.g i have sheets with codename wstemp4, wstemp2, wstemp3 which shall be order like ...Answered | 8 Replies | 1017 Views | Created by zaveri cc - Wednesday, December 30, 2015 9:54 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Sunday, January 3, 2016 11:59 AM
-
0 Votes
Code needed for excel sheet
locations. Currently, I am using find and select to input the numerical values from the barcode reader. I am looking for a code which uses the same "pop ... -
0 Votes
Adding VBA code to Excel sheet
easily, but requires some VBA, to define a Worksheet_Change(ByVal Target As Range) function. My question is: is there a way to write VBA code into an Excel ...Unanswered | 4 Replies | 3694 Views | Created by Ad Brandt - Tuesday, May 22, 2007 9:27 PM | Last reply by LauraDMSWriter - Wednesday, May 23, 2007 6:54 PM -
0 Votes
VBA Code for Excel
have to go through each and every time have to repath the file to the v drive? Below is the code. Sub ...Answered | 1 Replies | 3695 Views | Created by Jeff G_6 - Wednesday, October 3, 2007 11:36 PM | Last reply by Shasur - Thursday, October 4, 2007 1:21 AM -
0 Votes
VBA code for excel
Use VBA to compare two columns in Excel and highlight the cells that are similarUnanswered | 1 Replies | 3319 Views | Created by Shynu - Monday, May 26, 2008 10:55 AM | Last reply by suznal - Tuesday, May 27, 2008 12:21 PM -
0 Votes
VBA code for Excel
I would recommend posting your question to the VBA forum: http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads Paul ~~~~ Microsoft MVP (Visual ...Answered | 1 Replies | 8484 Views | Created by Sathishreddy - Friday, December 4, 2009 4:44 PM | Last reply by Paul P Clement IV - Monday, December 7, 2009 6:57 PM -
0 Votes
VBA code for use in several worksheets in a workbook
functions are almost the same with the exception of the name of the worksheet. I noticed that when I have the vba code window/editor open there is a tab and a window ...Unanswered | 1 Replies | 4036 Views | Created by Patrick14 - Friday, November 10, 2006 11:42 PM | Last reply by ADG - Saturday, November 11, 2006 4:45 PM -
1 Votes
Problem with VBA code (Excel Sheet Copy without VBA Code) (File Expiration Date)
and that is what you give the user. If you need code to process what the user has entered in the sheet then use VBA code to copy their worksheet to the ...Unanswered | 2 Replies | 472 Views | Created by developersk - Friday, January 6, 2017 5:17 AM | Last reply by Chenchen Li - Tuesday, January 10, 2017 7:23 AM -
0 Votes
Compiling Excel VBA-code?
I have been developing Excel VBA Applications for some years now and as far as I know there is nothing that will compile the code (except the compile option in the ...Answered | 1 Replies | 5146 Views | Created by PC MacLeif - Friday, May 12, 2006 5:11 PM | Last reply by ChasAA - Friday, July 21, 2006 9:09 AM -
0 Votes
Insert VBA-Code in Excel-Sheet via C#
My C#-App works in these order Add a new WorksheetRename it to "MySheet"Later in my Application I want to add a VBA-Code to the this ... -
1 Votes
link to VBA code from a excel sheet
For information - here is an alternative to Andy Popes excellent workaround for Hyperlink to Code Subroutine: I found a way using Excel ...Answered | 8 Replies | 7781 Views | Created by sanjaytw - Tuesday, October 13, 2009 6:21 AM | Last reply by Kubiszyn - Tuesday, January 22, 2013 11:17 PM -
0 Votes
Excel VBA code to move the data to sheet 2
Hello Developers, The below code to move selected range of data works well but it removes the hyperlink. For e.g Column A has hyperlink to some websites and other ...Answered | 1 Replies | 678 Views | Created by zaveri cc - Tuesday, November 26, 2013 4:18 PM | Last reply by Hans Vogelaar MVP - Tuesday, November 26, 2013 4:26 PM -
0 Votes
Lock Excel Sheet using C# code
Hi Vin, Thanks your code is working.I have some Queris While i open the excel Sheet its showing a DialogBox ...Answered | 17 Replies | 12625 Views | Created by Syed Shakeer Hussain - Monday, May 30, 2011 9:42 AM | Last reply by Patrice Scribe - Wednesday, June 1, 2011 4:44 PM -
0 Votes
VBA code executes accross multiple worksheets.
I am exporting several queries to one Excel workbook with mulitple worksheets (1 worksheet for each query). I then need to run some cleanup code on the ...Answered | 1 Replies | 579 Views | Created by Kode Hunt - Friday, October 17, 2014 5:33 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Friday, October 17, 2014 6:55 PM -
0 Votes
Generate Sheet Name using vba
Hi, I want to store the Sheet Names of a workbook from my Current Workbook. For example, I have a browse button which will help me to select an excel ...Answered | 6 Replies | 482 Views | Created by Deb_chatt - Friday, September 11, 2015 8:33 PM | Last reply by Deb_chatt - Saturday, September 12, 2015 8:44 AM -
0 Votes
VBA code - if slicer is included on Excel sheet
Within VBA I would like to check if specific slicers are included (visible). I'm setting up a macro to add/delete specific slicers based on criteria, so need to check if a slicer is ...Proposed | 1 Replies | 279 Views | Created by trinakropf - Thursday, April 13, 2017 3:09 PM | Last reply by Chenchen Li - Friday, April 14, 2017 6:58 AM -
0 Votes
vba Excel macro code
You can use conditional formatting for this, no need to use VBA. Select the rows in Worksheet1 that you want to colour. I will assume that the active cell within ...Unanswered | 1 Replies | 653 Views | Created by m.gharaibeh - Friday, March 15, 2013 1:17 PM | Last reply by Hans Vogelaar MVP - Friday, March 15, 2013 1:36 PM -
0 Votes
VBA Excel - import two worksheets
Using an unqualified sheet object may mean you are looking in the wrong workbook. Better to use the workbook object as well.. Further, the Sheets collection is not the same as ...Proposed | 1 Replies | 1104 Views | Created by Semperfi4000 - Tuesday, June 3, 2014 6:31 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Tuesday, June 3, 2014 7:04 PM -
0 Votes
Using VBA with Hidden Excel worksheets
I was trying a code using .find parameter on hidden and very hidden works fine. you do not need to ...Unanswered | 2 Replies | 496 Views | Created by Roget Luo - Tuesday, March 14, 2017 8:11 PM | Last reply by VBATools - Wednesday, March 15, 2017 1:38 PM -
0 Votes
How to clear partially an Excel sheet within VBA code?
Dear all, I have a question about VBA Excel, and I would appreciate if you could kindly give me a hand. Suppose that ...Answered | 3 Replies | 7107 Views | Created by dariyoosh - Friday, April 30, 2010 3:13 PM | Last reply by dariyoosh - Monday, May 3, 2010 9:14 AM - Items 1 to 20 of 2735729 Next ›
No announcements
