Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2017, 08:58 AM
NoSparks NoSparks is offline Adding a function to this macro: Windows 7 64bit Adding a function to this macro: Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

What exactly do you mean by this ?
Quote:
As a secondary request, I'd love to build in some way to refuse csv pasting with too many values for the intended array.

Reply With Quote
  #2  
Old 12-20-2017, 05:42 AM
JohnGanymede JohnGanymede is offline Adding a function to this macro: Windows 7 64bit Adding a function to this macro: Office 2010 64bit
Novice
Adding a function to this macro:
 
Join Date: Jul 2017
Posts: 9
JohnGanymede is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
What exactly do you mean by this ?
The project is a calculator tool. I'm trying to idiot proof it for users. In the above macro I'd like to set the acceptable range for pasting csv data, in this case C5:E14, and if the paste is too many columns or too many rows, I'd like it to exit the sub. A rejection notice of some kind would be nice.

It's not critical, but would be great.

I'm still sorting out the suggested IfEmpty function. It looks promising. This is a hobby application. I'm no pro and just doing this in my spare time.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a function to this macro: Adding to a macro Ulodesk Word VBA 4 03-07-2016 01:40 PM
Adding a function to this macro: Sum function not adding correctly rs456a@att.com Excel 4 05-28-2015 11:48 PM
Compiling/Indexing hundreds of recipes + adding a search by ingredient function. batarcit Excel 2 08-13-2014 03:09 PM
How do you write a macro with an IF Function Scheuerman1987 Excel 5 06-05-2013 06:04 AM
Adding a function to this macro: Help! for using an appropriate function/Macro in Excel pawan2paw Excel 1 06-04-2009 12:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft