 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / December 2005VBA excel problem with one code line
Hi Following code doesn't work like my idea. ==================== Sub Makro8() ' Makro8 Makro ' Makro am 30.10.2005 von - - aufgezeichnet ' Wählt den Bereich von A2 bis zur letzen Zelle mit Inhalt aus. Ist falsch 17:12:2005' Range("A2").CurrentRegion.Select End Sub ==================== The code mark the range from A1 and not from A2. The end is OK. In a book for VBA Excel Handbook for WIN I red following code Worksheets(2).[b2].CurrentRegions is a Range Objekt with all cells starting from B2 My code fundamental is OK, it comes no error message Can someone help me ? Is there a big differnece between VBA for WIN and OS X ? I haven't found no OS X specific VBA Forum.. Thanks Jochen (.de) > Following code doesn't work like my idea. > [quoted text clipped - 12 lines] > > The code mark the range from A1 and not from A2. The end is OK. The CurrentRegion property includes a range surrounding the target cell on *all* sides until it's bounded by blank rows and columns. So if you have a value in a row 1 cell, row 1 will be included, as long as there's not a blank column that separates the row 1 cell from the target cell. > In a book for VBA Excel Handbook for WIN I red following code > [quoted text clipped - 4 lines] > > Can someone help me ? What is it that you're trying to do? If you want to exclude column 1 and row 1 from the current region, one way is: Intersect(Range("A2").CurrentRegion, Range("2:" & Rows.Count)).Select but there may be better ways, depending on your worksheet layout. > Is there a big differnece between VBA for WIN and OS X ? MacVBA (both OSX and previous) are VBA5, which is also the version for WinXL97 VBA. More recent WinXL versions use VBA6. There are additional commands in VBA6 (such as Replace, Join, Split, Round). There are also a few relatively minor differences in syntax, primarily with I/O functions (for instance, the GetSaveAsFilename method's FileFilter argument). > I haven't found no OS X specific VBA Forum.. There is none - this microsoft.public.mac.office* newsgroup hierarchy is the place. @JE McGimpsey Thanks for your answer. I will read your text but. I need some time because my english is not so good. If I have additional question I will ask here later. Jochen (.de) My aim is following I will (must) create a lot of diagramms The values are not stored from A1 : H2350. In reality the values are stored from A15 : H2350 in one sheet or A15 : H1330 or A15 : H4370 and so on. The first values also in the same cell the last values are in different cells. I'm not an expert in VBA so I have simple questions Jochen (.de) Heeeeeeeeyyyy I found the solution with your answer. I insert a blank line before the row A15 : A15 The I can start in A15 and the code marked the range A15 : H2350 Jochen (.de) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.