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
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 139
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 114
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 123
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 106
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 102
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 113
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 114
Display one sheet or two userforms while code is vba code is runningon another by RJQMAN[_2_]
I have VBA code that freezes and unfreezes windows on a worksheet while it searches for the best presentation. Although it only takes 10 seconds or less to...
December 30th 09 01:15 AM
by RJQMAN[_2_] Go to last post
2 126
Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell) by Tim Williams[_2_]
Why would you want to do this? Tim "Naji" > wrote in message...
December 30th 09 01:05 AM
by Tim Williams[_2_] Go to last post
0 112
Copy whole table into one cell by Tim Williams[_2_]
You can't copy a table into a cell. Best you could do is convert to text, and use a non-proportional fonf (fixed-width, like courier for example) and pad...
December 30th 09 01:02 AM
by Tim Williams[_2_] Go to last post
0 121
Data Bars by Doug
How can I place data bars in column N with respect to percentages in column CI ranging from 0 - 100? I am doing this so to overlap some pertinent...
December 30th 09 12:56 AM
by Tim Williams[_2_] Go to last post
4 150
Declaring an array variable by OssieMac
Hi Bill, Not sure the following is what you are looking for. Because you said you want the borders on several ranges I have included code demonstrating the...
December 30th 09 12:07 AM
by OssieMac Go to last post
0 115
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) by Dave Peterson
Check one of your other posts. Naji wrote: > > Is there a way to do this via VBA or formula? > > I want to show the values that are added instead of the...
December 29th 09 11:40 PM
by Naji[_2_] Go to last post
1 104
Disappearing Graphs by Paul E[_2_]
Joel, Before adding the zoom logic I would run this w/ the updating set to false. When I run it w/ the zoom logic, I have that commented out. So, no errors....
December 29th 09 11:23 PM
by Paul E[_2_] Go to last post
0 130
Macro to delete rows that contain specific words by Neil[_29_]
Hi Ron, Thanks for the link - works perfectly! Cheers Neil
December 29th 09 11:13 PM
by Neil[_29_] Go to last post
0 160
copy and paste whole worksheet from one workbook to another by Allen the Computer Guy
I need to copy an entire worksheet from one workbook to another. Currently, i am using the following code: Set objExcel =...
December 29th 09 11:06 PM
by Allen the Computer Guy Go to last post
3 179
Trying to determine if macro is possible by OssieMac
Hi Chris, Ensure that you have a backup of your workbook before running the following macro in case it does not do exactly what you expect. Note the...
December 29th 09 10:55 PM
by OssieMac Go to last post
3 141
Type Mismatch with UBound and arrays by DG
Got it. "DG" > wrote in message ... > Actually I still have a problem. > > I used your...
December 29th 09 10:42 PM
by DG Go to last post
0 156
how to move sheets from one workbook to another by vicky
I need a vba code to MOVE the COPY of sheets from input.xls To thisworkbook . "VBA code For Moving The Copy oF sheeets"
December 28th 09 11:56 AM
by vicky Go to last post
0 161
Automating adding/deleting rows and content with macros (I suppose by Kass
Hi all, I currently have three tabs on my Excel file, say "output1", "output2" and "database" in which information in the database tab will appear in the...
December 28th 09 11:10 AM
by joel[_430_] Go to last post
1 108
Post New Thread


Display Options
Showing threads 10001 to 10020 of 173995
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 02:09 PM.


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