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
Paste To Visible Cells Macro by WBTKbeezy
Hello: I was trying to find a way to paste into visible cells only. I found a macro on another site and have pared it down to the following: Sub...
July 26th 12 11:03 PM
by Renato Vieira Go to last post
9 1,186
I'm getting unwanted rounding to integer for an average of range of cells. by [email protected]
I'm trying to return an average value for a variable range of cells using this line of code: rangeavg = WorksheetFunction.Average(Range(n1 & o1 &...
2 397
Cell Count Between Value by JAgger1
Is there a simple formula for getting cell count beween a certain value? Example: In column A1:A8 I have the following numbers. 1 3 6 9 6
(Multi-page thread 1 2)
July 26th 12 03:08 AM
by Ron Rosenfeld[_2_] Go to last post
15 881
Mail a different file(s) to each person in a range by djar
Hello, I needed to mail files to people in a ranges. I am using the following code. This works perfect when the filenames are STRINGS, but if the filenames...
July 26th 12 12:02 AM
by djar Go to last post
0 395
Would like to create customized named range by kpink
I have a fairly detailed data set that I would like to base named ranges off of. The thing is, the data set changes quite often. I would like to list a range...
July 25th 12 03:13 PM
by Don Guillett[_2_] Go to last post
2 371
Macro to copy rows into worksheets by cupcakex
Ill try to explain best I can. Recently found (finally..) a macro to auto create worksheets named after whats in Column A (5 digit number). I have one master...
July 25th 12 02:07 PM
by cupcakex Go to last post
4 504
Copy filtered data to sheet 2 by Jim Lavery
The filter works & it goes to the available cell in sheet2 but doesn't paste the filtered data. Any ideas? 'Option Explicit Function FilterAndCopy(rng As...
July 25th 12 01:55 PM
by pascal baro Go to last post
1 436
Filtering/Excluding Values by KeriM
I'm trying to filter values on two columns, then count the number of rows remaining with the result displayed in a pop-up message box, and then exclude values...
July 25th 12 01:51 PM
by pascal baro Go to last post
2 748
Run-time error 57121 & 32809, Excel 2003 SP2 by Adrian C[_2_]
Hi, As far as I know, Microsoft has no answer for the following issue on the PC platform. This fault corrupts the VBA code module - the only way to rescue...
July 25th 12 12:43 PM
by jazper Go to last post
2 3,393
Adding Multiple images in in an email body by amitmehrotra123
HI I am new to this forum and excel programming. I have created a macro and wants to place one image on top of another in the body of an email. Instead of...
July 25th 12 04:45 AM
by amitmehrotra123 Go to last post
0 360
Excel 2007 Access the Content Created File property in vba by [email protected]
Hi I have just changed job and have upgraded from excel 2003 to 2007 and I use to use the date created property in getfile().datecreated to find out when the...
3 1,193
Align cells with same value - vba almost working by bpascal123
Hi cyberspace, I have spent quite some time trying to make this work but at this point from adding many msgbox checks, using the watch window for variables...
(Multi-page thread 1 2 3 ... Last Page)
July 25th 12 01:19 AM
by pascal baro Go to last post
43 2,606
Please help! with find/copy/replace by ksquirt
I have tweaked a macro to do all kinds of new things thanks to searching for answers on this forum. My current issue is that it is skipping a cell. It...
July 24th 12 11:35 PM
by pascal baro Go to last post
1 466
creating multiple charts at each change in variable by JG Scott
I have a table with the following structu Company Sales Receivables At each change in "Company" I would like to create a bar graph of "Sales" and...
July 24th 12 05:16 PM
by JG Scott Go to last post
0 386
Using IE from VBA - Permission Denied by Madiya
Here is my code. Dim ie As InternetExplorer Dim ipf As Object Set ie = CreateObject("InternetExplorer.Application")<<<<<this is failed line I have set...
July 24th 12 01:05 PM
by Madiya Go to last post
2 1,232
VBA macro Trignometry function by Spint
Hi, I am very much new to VBA programming, started just two days ago. i need to write a code which uses cos and sin functions. i tried using Sin and Cos...
July 24th 12 12:44 PM
by Spint Go to last post
2 695
Need help with please.. by Vacuum Sealed
Hi all I have 20k rows representing a whole year of activity of delivering into 5 DC's. What I need to do is get a figure of how many of these DC's got...
July 24th 12 11:36 AM
by Vacuum Sealed Go to last post
2 417
Page Breaks in VBA Q by [email protected]
I have the macro below to print a range A:HB to 29 pages, problem is however that the Page breaks are not consistent, how can I alter the page breaks within...
6 491
Excel 2010 record macro default save to thisworkbook by John[_139_]
I recently upgraded to Excel 2010 and now when I record a macro the default location for saving this macro is personal.xls. Is it possible to change that...
July 24th 12 03:37 AM
by John[_139_] Go to last post
0 512
check box by kalpesh
Hello, in sheet1 i will create button to print out data in sheet 1 but my probelm some time i need 2 copy of print so need to make checkbox when i...
1 291
Post New Thread

Display Options
Showing threads 2001 to 2020 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 10:17 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.