-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Announcements
MrExcel Message Board FAQ & Help
FAQ, Rules & Guidelines, General Board Help
Question Forums
Excel Questions
All Excel/VBA questions - formulas, macros, pivot tables, general help, etc.
Please post to this forum in English only.
Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.
Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.
- Threads
- 1057448
- Messages
- 5.4M
Questions in Other Languages
Ask any Excel questions in your native language (questions in languages other than English only, please).
- Threads
- 1724
- Messages
- 7.4K
Power BI
Business Intelligence Tools: Power Pivot, Power View, Power Query, DAX Formulas
- Threads
- 7629
- Messages
- 30.8K
Microsoft Access
Questions about Access.
- Threads
- 32922
- Messages
- 149.7K
General Discussion & Other Applications
This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.
- Threads
- 7657
- Messages
- 30.4K
MrExcel Products
MrExcel's Products: Books, CDs, Podcasts
Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
- Threads
- 579
- Messages
- 2K
Other Forums
About This Board
Discussion of policies, bug reports, how to use it, XL2BB questions, etc.
- Threads
- 2587
- Messages
- 14.5K
Excel Articles
Discussions about existing Excel Articles published in the forum. You can not start a new thread here. To contribute an article, click Excel Articles in the Top Nav Bar and then use the orange button on the right: Add Excel Article....
- Threads
- 38
- Messages
- 244
Excel LAMBDA Functions
Have you written a useful LAMBDA function that might be useful to others? Post it in the forum. The community can vote for their favorites and we'll suggest to the Excel developers ideas that could be added to the core Excel functions.
* Required to be an active member who has more than 50 posts to submit functions.
* Required to be an active member who has more than 50 posts to submit functions.
- Threads
- 174
- Messages
- 500
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
- Threads
- 2170
- Messages
- 2.2K
Hall of Fame Winners
An announce-only forum to spotlight classic message board solutions.
- Threads
- 14
- Messages
- 17
Test Here
Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc.
Threads in this forum are automatically deleted after no replies for seven (7) days
Threads in this forum are automatically deleted after no replies for seven (7) days
- Threads
- 2
- Messages
- 3
Forum statistics
Share this page
This Week's Hot Topics
-
I.E A2=D2 on another page i need my macro to go from A2 to J column
- Started by svis89
- Replies: 54
[CODE=vba]Sub Bought_1() Range("D2").Activate If ActiveCell = vbNullString Then Exit Sub Selection.Copy RngB = Range("B2").Value Sheets("Count... -
SUM a same cell in the RANGE of sheets using SUMPRODUCT(SUMIF(INDIRECT
- Started by Tatiana_k
- Replies: 40
Hi guys, I need to sum all A1 across many sheets with daily data and then put the result in summary sheet and apply this formula to 365 rows in... -
Macro to save and separate multiple worksheets as individual files in .csv format
- Started by Ay Sticky
- Replies: 37
Please I have multiple worksheets in a workbook saved in xlsx. The task I need the vba for, is to separate these worksheets into individual... -
Error with VBA for naming sheet from cell
- Started by leecavturbo
- Replies: 29
I have a pretty standard VBA worksheet name from cell data. but every 7th worksheet or duplicate data the worksheet name references incorrect cell... -
VBA to save rows as CSV without empty rows
- Started by Jorgi
- Replies: 26
Hello may I ask you to help me with VBA. I would like to save data via macro as CSV but only if there is a data. Every 6 rows equal to one piece... -
SUMPRODUCT with (space) Intersection operator
- Started by jackms
- Replies: 23
I have a range name that consists of non-contiguous columns. I can use the (space) Intersection operator with functions like SUM and AVERAGE ...
