Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Functions to get range properties

That works as a cell formula, but I need it in VBA. So if I do
something like:

Application.WorksheetFunction.Min()

Then the Min() function expects as series of arguments [arg1], [arg2],
[arg3], etc. I don't know how to turn COLUMN(C1:F1) into an array or a
series of arguments without a lot of extra code.

Any tips would be great. I hate writing and using code that re-invents
the wheel, and I have a suspicion that I have.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using the address properties from range objects in a sum formula JEFFWI Excel Discussion (Misc queries) 2 September 11th 07 05:36 AM
Data range properties baz Excel Discussion (Misc queries) 1 April 1st 05 09:37 AM
data range properties baz Excel Discussion (Misc queries) 0 April 1st 05 08:53 AM
Updating range properties is so sloooow!!! Frank_Hamersley Excel Programming 9 June 19th 04 08:43 PM
Range properties Krisztian Pinter Excel Programming 0 October 16th 03 04:47 PM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"