| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me to find out number of column occured
Please help me to find out number of column occured between
activecell and A7 For example current column M7 . I want to find out the number of column between the column M7, A7 It would be very helpful to me please help With thanks Pol |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help me to find out number of column occured
Try
=COLUMN()-COLUMN($A$7)-1 If this post helps click Yes --------------- Jacob Skaria "pol" wrote: Please help me to find out number of column occured between activecell and A7 For example current column M7 . I want to find out the number of column between the column M7, A7 It would be very helpful to me please help With thanks Pol |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help me to find out number of column occured
xValue = Range(ActiveCell, "A7").Columns.Count
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "pol" wrote: Please help me to find out number of column occured between activecell and A7 For example current column M7 . I want to find out the number of column between the column M7, A7 It would be very helpful to me please help With thanks Pol |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
| Find max Row() number for a value in column | Excel Worksheet Functions | |||
| find the largest number in column | Excel Discussion (Misc queries) | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Hybrid Mode
