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
VBA error 1004 on With worksheet.Paste by AJ Master
I have a worksheet with data that I sometimes want to copy to 3 other worksheets rather than entering the data on each sheet individually. I just recently...
March 31st 16 07:30 PM
by GS[_6_] Go to last post
4 560
Deleting rows from a structured table based on the value of a column by [email protected][_2_]
I'm using the code below to delete rows from a structured table based on a column having a zero value. In the table I have there are 6 rows with a zero value...
2 446
F1 help in VBA environment opens sheet; send VBA to background. Howto stop? by [email protected]
Pressing F1 on a highlighted keyword in the VBA code editor now brings me directly to the proper uS online document. But at the same time, Excel opens the...
0 977
Trouble Counting how many times a Cell Value Occurs when Condition isin a Row and not a Column by Munster
Here's an example of the issue I am running to A B C D 1 GolfA Birdie Par Bogey 2 GolfB ...
March 26th 16 07:37 PM
by MM[_5_] Go to last post
2 377
Hyperlink usage by Walter Briscoe
I wish to count bus stop usage in London. Sheet1 has about 1000 rows. Each row has up to 2 hyperlinks elsewhere to information on the stops in a particular...
March 19th 16 08:51 AM
by Walter Briscoe Go to last post
7 657
Copying down conditional formatting alone by Walter Briscoe
I have some Excel 2003 documents. All cells have 3 Conditional Formatting rules. The same Conditional Formatting rules apply to all cells. Each rule is a...
March 17th 16 09:37 PM
by Walter Briscoe Go to last post
2 435
Remove unicode characters from cell containing values by [email protected]
Pls assist with macro how to remove invisible unicode characters in a cell Thxs A
March 13th 16 03:44 AM
by GS[_6_] Go to last post
6 506
Hide colums based on a value in cell A1 (refered to the number in thefirst row of each column) by [email protected]
Hello everybody, Can somebody help me out, In Column B till.... in the first row a number is registered. In cell A1 is shown a nr for which columns I have...
March 11th 16 07:25 PM
by Claus Busch Go to last post
1 400
Hide rows without data in a column based on active cell by [email protected]
Hello, I like to have a module which takes below action. The mean heading is row 2. When selecting one of the records in row 2 (for example cell D2) I want...
9 559
Set the copy to column to a variable by L. Howard
I am bogged down on how to use this formula... =COLUMN(INDEX(B1:CZ1,MATCH(A2,B1:CZ1,0))) To set these lines to the correct column number... aScan.Cut...
March 6th 16 05:30 AM
by L. Howard Go to last post
9 618
Filling a macro button with colour ( color) by Chris Maddogz
I have a spreadsheet with 7 lovely macro buttons on it that automatically execute lots of important jobs but look pretty boring in their basic colouring (...
5 483
COUNTIF VBA by Merritt Ave
Hello - I wanted to incorporate a COUNTIF in VBA (not onto the spreadsheet) that will precede this code. I would like the COUNTIF to first assess whether an...
March 4th 16 02:44 PM
by Claus Busch Go to last post
3 477
VBA project does not close when workbook is closed by Simon Norris
I have a large project that uses VBA to open and close files. The project is password protected. I recently ran into a problem whereby a password prompt...
March 2nd 16 05:34 PM
by GS[_6_] Go to last post
5 691
Worksheet Change event question by Phrank
Hi. How might I apply a worksheet change event to the active cell? On my worksheet, a user will enter a number in a cell (column B). I want to make that...
March 2nd 16 12:08 PM
by Phrank Go to last post
3 412
Conditional formatting activecell offset by L. Howard
I assume to use Worksheet_SelectionChange(ByVal Target As Range) Whe if I select cell A2 then cell C1 is highlighted. if I select cell A3 then cell E1...
February 28th 16 05:55 PM
by L. Howard Go to last post
5 453
Columns I to Q range variable definition by L. Howard
What's a better way to capture the range of Columns I:Q down to last row the with an entry. I don't know which column will have the longest list of data. I...
February 26th 16 04:54 PM
by L. Howard Go to last post
5 440
Insert from paint and resize by [email protected]
Group: microsoft.public.excel.programming https://groups.google.com/forum/#!topic/microsoft.public.excel.programming/UqUQQ0Qokpg Subject: insert from paint &...
9 557
Currency change via vba by [email protected]
Help please . . . . I want a user to be able to select a currency from a drop-down and the following macro will change certain cells to that currency. SO far...
February 25th 16 06:44 PM
by Claus Busch Go to last post
7 563
insert from paint & resize by [email protected]
Hi I hope someone can help with this. I use the code below which launches MS Paint, the user then signs within Paint (using the Touchpad on a laptop) the...
0 401
Excel Experts by Varinder Singh
Dear All, Need help ! A 1 1 2 2 1
February 25th 16 12:22 PM
by Claus Busch Go to last post
1 395
Post New Thread

Display Options
Showing threads 201 to 220 of 174022
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 07:15 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.