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
Data Cleaning Macro Continues to generate Error by James[_48_]
Hello - We created a Macro that cleans a series of Book Titles in Column A of Sheet 1. The way it works is the Phrases in each Cell of Column A of Sheet 2...
May 18th 17 11:05 PM
by Claus Busch Go to last post
1 85
Retrieving records from closed Excel workbook by hbj
I need a simple way of retrieving records from a worksheet - with headers - in a closed Excel workbook using SQL. But I also want VBA to detect the Excel...
May 15th 17 08:55 PM
by GS[_6_] Go to last post
3 117
Copy one cell and merge into another by [email protected]
Hi, Is a macro for this possible? 1. Active cell (is a number) 2. 4 cells to the right from active cell (is text) 3. Add the value from the first cell (1) at...
May 12th 17 05:25 PM
by GS[_6_] Go to last post
3 130
Input box, find number and go to cell by [email protected]
Hi Can someone help with a macro doing the following? 1. Open an Inputbox (User then writes a number with four digits) 2. Search for the number in column A...
May 10th 17 08:43 PM
by GS[_6_] Go to last post
7 125
Error Executing a Macro on Opening Q by [email protected]
I'm hoping some one can hell with an error that has been happening on some code, that previously worked with no issue for several years. I run a small Batch...
May 9th 17 08:12 PM
by GS[_6_] Go to last post
3 112
Incorrect number entry on Excel for Mac 2011 by kenrock
Hi, Recently, I find that when I open a workbook and type into any cell, a number, say 123, and press enter then the cell shows 0.123. Somehow, every number...
April 30th 17 08:58 AM
by kenrock Go to last post
2 194
Breaking apart email addresses that list more than one on a row by [email protected]
Hi, I'm in Excel 2013 for this question. I routinely get system generated email lists and unfortunately they don't come to me in the format that I need. I have...
April 28th 17 09:04 PM
by GS[_6_] Go to last post
1 92
Code to filter a pivot table by Phrank
Hi, I've got a workbook that is connected to an external dataset. The workbook is just a pivot table that pulls data from the external dataset. It shows...
April 28th 17 11:56 AM
by Phrank Go to last post
0 75
New Newsgroup by JCO
Anybody know a good newsgroup for C++ Programming? Thanks
April 24th 17 02:32 AM
by Auric__ Go to last post
3 249
list 2 cell values in saveas filename by Sabosis
Hello I am trying to use VBA to save a file and want two cell values in the new filename. One is a text value in cell B2, the other is a date in cell B1. I...
April 21st 17 08:29 AM
by GS[_6_] Go to last post
1 137
Help with adding hyperlinks to images by PA[_2_]
Hi, I have a code to add hundreds of pictures to a sheet. It works perfectly! Now I need to modify it to add a hyperlink to each picture and I cannot get it...
April 17th 17 05:40 PM
by PA[_2_] Go to last post
0 169
Macro Required - 13th April 2017. by Akash Maheshwari
Hi, Require Help!! I have three workbooks: ABC.xls DEF.xls Summary.xls
April 17th 17 11:21 AM
by Bruno Campanini[_2_] Go to last post
2 199
IP address to Hostname in Excel by nicktruman
Hi, I am hoping someone can help me please.. I have a spreadsheet that is linked to a survey being hosted on our website. The survey is about internet safety...
(Multi-page thread 1 2 3)
28 1,036
Call subroutine based on combination of Option buttons (two groups) by Robert Logan
Goal: Calculate average precipitation based on Month and Year. Worksheets: "2016" and "2017" Option Buttons: OptionButton1, OptionButton2, OptionButton3,...
(Multi-page thread 1 2)
April 12th 17 08:11 PM
by cacuoc334465c Go to last post
14 292
Excel and VBA calculate the same formula differently by Ottmar Brandau
I have a strange phenomenon. In Excel the following expression: LN(8/PI()^2*280/125) equates to 0.596458. In VBA the code: Log(8/(4*Atn(1))^2*280/125 comes out...
April 12th 17 04:46 PM
by hoclaixenang Go to last post
9 199
Embedding Existing Excel chart into VB6 form by [email protected]
This is a code for vb6 programmers --------------------------------- Dim xl, wbk Private Sub Command1_Click() Set ThisChart =...
April 8th 17 09:28 PM
by GS[_6_] Go to last post
2 157
Using timer to refresh webpage by Living the Dream
Hi Team As the title suggests. I am hoping someone can assist me with the following. Using the timer code, I would like to refresh a specific webpage. This...
April 6th 17 12:45 AM
by Living the Dream Go to last post
0 199
Formatting multiple sheets within workbook. by Living the Dream
Hi Team Workbook has anywhere from 30 to 40 sheets at any given time, of which approx that 25 - 30 require formatting. As there are sheets that cannot be...
(Multi-page thread 1 2)
April 3rd 17 12:12 PM
by Living the Dream Go to last post
17 350
How can we paste data on Google.com by Vipul Purohit
Hi FOlks I have successfully copied the range and opened the internet explorer and unable to paste it in google.com here is code.. I am quite new with VBA, I...
April 1st 17 12:12 AM
by isabelle Go to last post
1 179
Change active cells - Excel 2010 by [email protected]
Hi, I want to change the active cell border colour to red for all sheets. Excel 2010 Can somebody please help. Margarida
March 30th 17 07:06 PM
by GS[_6_] Go to last post
1 147
Post New Thread

Display Options
Showing threads 1 to 20 of 174039
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 06:00 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.