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
range does not return limits correctly every time by [email protected]
VBA experts, Please help with an explanation as to why this code is failing sporadically.. Lately, it works about 50% of the time. I'm running Excel 2010...
February 9th 16 07:55 AM
by GS[_6_] Go to last post
7 480
Help with VBA and Counting Conditionally Formatted Cells by Munster
I am trying to count conditionally formatted cells based on how many times specific colors appear between a set amount of cells and rows. I am very new to VBA...
February 7th 16 01:10 AM
by Claus Busch Go to last post
1 319
Question by PeCoNe
Hallo, i enter in cell B4: =Excel.Sheet.8|'D:\MyDocuments\Files\QtsXXX.xlsx'!'!Qts!dAEX' and excel changes it...
February 6th 16 10:52 AM
by PeCoNe Go to last post
2 292
global user-defined name (range) - or help with holidays by Matthew Dyer
not sure if should post here or in the main excel group, but since i'm utilizing VBA i'll put it here first. on sheet1.xlsm i have a user defined name range...
February 5th 16 06:27 PM
by GS[_6_] Go to last post
3 320
I need help cross referencing... by [email protected]
We got a new system at work for inventory and now have new part numbers. I have a file with the old part numbers and one with the new numbers and need to...
February 5th 16 02:56 PM
by Claus Busch Go to last post
4 278
Concatenating strings into a variable by [email protected]
Can't seem to find this anywhere and it should be simple. I have an array ActiveEmp "John", "Joe", "Bob", etc. I have variables named "UPD_John", "UPD_Joe",...
9 507
Hash (MD5) in Excel by Stephen Bullen[_3_]
Hi Ale, > i need i cell to get the Hash (MD5) value of a group of cells.. I just knocked this up from some similar code I did a while ago. The function can...
January 29th 16 01:56 AM
by GS[_6_] Go to last post
2 3,330
Issues comparing the values of 2 input boxes to cells and have eithervalue be able to be text or numeric by goaljohnbill[_2_]
So I have this code to replace an original value with a user entered one; ' dim as variant so that if = false works on both cases ...
January 27th 16 07:23 AM
by Claus Busch Go to last post
2 299
Graphics quality degrading by [email protected]
I wonder if anyone can help with this please . . . I am inserting images via some code provided previously from Robert via this NG; I then have code which...
January 26th 16 09:31 PM
by GS[_6_] Go to last post
3 413
activex Control (ComboBox) by jon michael de leon
How to code in vba excel 2013, Scroll it down using scroll mouse key
January 25th 16 06:28 PM
by Peter T[_7_] Go to last post
3 386
Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help by [email protected]
I need to make an excel cell find a value in another cell and if the value is there display a specific word in the selected cell, so basically the text in a1...
6 448
Extract Data from Dataset by [email protected]
I'm looking to extract data that meets a certain criteria but not sure how to do it via a macro. What I'm after:- Workbook1= Dataset Workbook2 = Where it will...
2 389
VBA Code for Hyperlink 23rd Dec 2015 by Akash Maheshwari
Hi Team, I have two sheets Go_To & Status_Report If a user clicks on a cell A1 of the sheet named as Go_To, then system should take me to the cell No C10 in...
January 18th 16 01:08 PM
by Mandeep Baluja Go to last post
2 588
Help Please - picture not embedding by [email protected]
Hi I found the code below (which I've adapted slightly)on OZGrid. I was under the impression this would embed the picture. However having tested it by...
2 385
Need help with a slightly modified Internal Rate of Return calculation by [email protected]
I need to find a "baseline" rate of return calculation that finds the baseline rate of return, given annual deviations from the baseline rate and the CAGR for...
3 615
Median Regression by [email protected]
Hello I am trying to work on Median regression analysis for some protein marker data: The data has age in weeks, protein marker value, the equation is: A*B...
0 565
Help needed: Conditional Formatting for 3 columns, any two of whichmust have data by pete
I have 3 columns, A, B, and C. Each will accept input of exactly 6 alphanumeric characters. Two of the three must be populated. The Conditional Formatting...
January 8th 16 02:51 PM
by pete Go to last post
3 519
Date range in Data Validation foiled by "Today()" function by pete
Hi, I've set up a date range in Data Validation to restrict entries to a certain period. In the date field, I've got "Today()" to default to today's date. ...
January 8th 16 02:18 PM
by pete Go to last post
5 506
Help with a simple macro by [email protected]
I have the following macro. Before I run it each time I have to edit the reference to "030" below (4th line from bottom). For example, I will edit it to...
January 7th 16 04:52 PM
by Claus Busch Go to last post
1 439
Question by Mandeep Baluja
Hey I would like to know how this works, How Excel file can be open with these generated usable password, what is the logic behinds this...
January 6th 16 03:16 PM
by GS[_6_] Go to last post
1 474
Post New Thread


Display Options
Showing threads 201 to 220 of 173994
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 01:45 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.