A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excel 2003 vsto 2005 vb.net - ThisAddIn_Startup problem by RichardB
Hello, I have an add-in that works well and executes the me.startup event perfectly when Excel is started manually. If Excel is started by double clicking...
December 30th 09 05:20 PM
by joel[_440_] Go to last post
1 319
VBA for comparing data within a range for Excel 2003 by marcus[_3_]
Hi You don't need vba to solve this one. A formula will work just as well. Put this in the appropriate cell and drag it...
December 30th 09 04:49 PM
by jmberner Go to last post
1 137
Problems with Workbook Before Save Event by Ryan H
Thanks for the replay Dave. I did think about doing your suggestion before I read your post, but I decided not too. This is the code that I had to...
December 30th 09 04:36 PM
by Ryan H Go to last post
2 167
Referencing a Forms Button in a Worksheet by Ryan H
Thanks for the reply Dave. I realize "-" are not allowed, but it did NOT throw an error when I assigned a name to the forms button on the worksheet, weird...
December 30th 09 04:00 PM
by Dave Peterson Go to last post
3 166
How can I print a frame corresponding to page margins? by Paolo Moia
How can I print a frame corresponding to page margins?
December 30th 09 03:32 PM
by Paolo Moia Go to last post
0 116
Consolidate data with text by John[_140_]
Excel Consolidate Data does not consolidate text. I need to somehow combine data from several different worksheets into one (the sheets contain text and...
December 30th 09 03:25 PM
by Dave Peterson Go to last post
2 118
Help by GC
Hello, I am trying to set the series of 4 different charts with data from 4 seperate sheets. My sheets are called S1, S2, S3 and S4. In the example below, I...
December 30th 09 03:20 PM
by Fred Smith[_4_] Go to last post
3 156
Inputs on one sheet dependent on which sheet is visible. by Shane
Thank you for your help. I figured a way around it. Shane "Shane" wrote: > I have created a workbook with a group of sheets that are agendas for client >...
December 30th 09 03:15 PM
by Shane Go to last post
0 115
Excel 2003: macro to add data to next empty row by Powerless user
When I run this macro with new data it overwrites instead of pasting to the next empty row in the destination sheet. Any suggestions? Sub Copy9365() 'Copy...
December 30th 09 02:55 PM
by GadyC Go to last post
3 213
Insert Formula in cells from VBA by Mouimet
Hi, I have different data related together on a sheet. I want to create a formula selecting the function depending the code I have in cell A7 The formula in...
December 30th 09 02:49 PM
by Mouimet Go to last post
2 125
Where is the ActiveX Spreadsheet control? by GadyC
I wrote an xla using the MS spreadsheet control. I recently change my computer and cannot find the conmponent. Where does it hide? my new env is: Win 7...
December 30th 09 02:43 PM
by GadyC Go to last post
0 108
Problems with Workbook Before Save Event by Ryan H
This is the code that I had to use. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With ThisWorkbook .IsAddin =...
December 30th 09 01:46 PM
by Ryan H Go to last post
0 165
Declaring an array variable by Rick Rothstein
Here is another way to structure your code... Sub AddBorders() Dim V As Variant For Each V In Array(xlEdgeLeft, xlEdgeRight, xlEdgeTop, xlEdgeBottom, _ ...
December 30th 09 01:32 PM
by fisch4bill Go to last post
1 164
Userform problem with "Run Time Error 75" by joel[_432_]
I think I found the problem. I set bIsLoaded = False in the function below. Without this statement the function was returing nothing which may of caused...
December 30th 09 12:12 PM
by joel[_436_] Go to last post
2 151
code to make a block arrow point from cell A to cell B by hermac
On 29 dec, 16:52, joel > wrote: > did you se my posting of rotating the arrow? > > Selection.ShapeRange.IncrementRotation 180 > > A...
December 30th 09 11:47 AM
by joel[_435_] Go to last post
1 128
Copy data from one worksheet to another by Stacey
I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I...
December 30th 09 10:40 AM
by Leung Go to last post
1 130
split problem by אלי
Hi all, I am interesting to break a string with spaces into an array with substrings and to have it in the same cell. for example: dim MyString as...
December 30th 09 10:31 AM
by אלי Go to last post
2 115
Checkbox variable by Basta1980
Hi Joel, Though the actual suggestion did not work for me it did give me an idea. I solved the problem by creating two checkboxes. Regards "joel" wrote: >
December 30th 09 08:10 AM
by Basta1980 Go to last post
0 111
Printing from a control button by Dave Peterson
I would think the save and print options would need some kind of "which of the open files do you want to save/print" question associated with them. So maybe...
December 30th 09 02:59 AM
by Dave Peterson Go to last post
4 120
Copy worksheet from one workbook to another workbook by David Ryan
Hi Joel thanks for that. i think it is almost there. when run the open file "box" opens when you select the file to open the following error message...
December 30th 09 01:16 AM
by David Ryan Go to last post
2 120
Post New Thread


Display Options
Showing threads 10001 to 10020 of 174008
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.