$$Excel-Macros$$ hiya

hi there have cells on another sheet of my workbook and was wondering how i use these to populate a combo box. alex cargill ps i use excel 2010 -- -- Some important links for excel users: 1. Follow us on TWITTER fo

$$Excel-Macros$$ Removing selected letters and symbols from a cell

Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24 AALPHA::HOTEL (447|319) K34 ALPHA::FOXTROT (445|320) K34 ALPHA::GOLF (446|319) K34 ALPHA::INDIGO (448|320) K34 ALPHA::JULLIET (449|319) K34 ALPHA::KILO

RE: $$Excel-Macros$$ Re: Help needed in changing this code

6, 6:05 am, Alexander Cargill wrote: >                          Hi all > > I have been working on the following piece of code to identify Blank > Cells and turn them red: > > Range("B2:B105").Select > >     Selection.SpecialCells(xlCellTypeBlanks).Select > >    

$$Excel-Macros$$ Help needed in changing this code

Hi all I have been working on the following piece of code to identify Blank Cells and turn them red: Range("B2:B105").Select Selection.SpecialCells(xlCellTypeBlanks).Select ActiveWindow.SmallScroll ToRight:=-1 With Selection.Interior .P

RE: $$Excel-Macros$$ How to alter the contents of a row in a sheet

s. Cheers!!, Andy On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill wrote: Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of th

$$Excel-Macros$$ How to alter the contents of a row in a sheet

Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button

$$Excel-Macros$$ inserting text to change contents off a cell

Hi all I was wondering if you could help, if you look at the following work book and the sheet that is called Bogy sets to attack there is co-ordinates in them, what I would like to do is select the contents off the column in a box (so I can selectively change them) and change the entry from XXX|X

$$Excel-Macros$$ Re: Is this possible and how

My fault for nt explaining J sorry my ma and much appreciated J From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack Sent: 22 October 2009 05:41 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Is this possible and how Hi Alex

$$Excel-Macros$$ Is this possible and how

Hi all in VBA 6.5 I have this code that i was supplied by one off your members which works fine: On Error GoTo Ext: Dim X As Range Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks) X.Cells(1, 1) = 7 X.Cells(1, 2) = 58 Ext: Exit Sub Having used this code on 50 Option buttons and changing the

$$Excel-Macros$$ Re: getting option buttons to work

many thanks for that code, it works a proper treat :, alex On 17 Oct, 01:37, Hemant Hegde wrote: > Use this code friend > > Sub Test() > On Error GoTo Ext: > Dim X As Range > Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks) > X.Cells(1, 1) = 1 > X.Cells(1, 2) = 30 > Ext: > Exit Sub > >

$$Excel-Macros$$ Re: getting option buttons to work

Hi there just wanted to say your code worked a treat, many many thanks to ya J alex From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant Hegde Sent: 17 October 2009 01:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: getting option

$$Excel-Macros$$ getting option buttons to work

Hi all im a bit off a noob and i was wondering iif you can help. I have a form with an option box I want the option box first search for the first blank cell in the D coulmn and then place the number 1 in the first available blank box in column D and in the ajacent cell the number 30 can anyone h