Search results

I'm sorry I'm no macro expert - I thought the article Chandoo sent out made sense but I seem to be missing something. I printed his posting out on three pages and walked step by step through it. It was then I ran into the problem error 424 Object Required. I posted a query and you responded...

Is this what you are telling me to do? Private Sub Worksheet_SelectionChange(ByVal Target As Range) [selRow] = Target.Row [SelCol] = Target.Column =CELL("address") End Sub Because this gives me a syntax error

Hi! I got this suggestion the other day and am working on a large spreadsheet range A2:Q695 which I am using to reconcile various items against each other and the ability to highlight the row and column I am in would be terrific. I followed the directions very carefully but after all is...

I use the freeze cells function all the time and in my old version of Excel I could set them up and save the file and the next time I came into the spreadsheet the titles were properly frozen. Since I have had the new version (2010) this function doesn't seem to be saveable any more. Every time...

Thanks for your help. The little finger is the shape of the cursor when you point to the Autofilter arrow normally rather than the arrow but it changes to a set of crossed arrows when I get into L & M for instance. I tried your macros but when I run them I get a debug error saying "Invalid...

The line is a series of Autofilter drop down selection buttons that run accross the first fourteen columns. The weird thing is that from columns A to D when I select the filter button I get the little white finger pointing to the cell. E&F the finger doesn't appear instead I get the cross of...

I have a spreadsheet which is set up with a line of sort keys across the top. Lately I have found that when I am trying to use the select button in the last three columns on the right I always have a text box popping up and yet my other columns seem to perform in their normal fashion. Can...

I ended up writing a formula that worked so my problem is solved but if you have a column of names and vacant cells between them that you want filled with the name in the first cell (A1) until the second name appears and then switches to that name until the third name, etc., etc., in Excel you...

I don't know how to

Sorry - I had it all spaced out the way I wanted it when I set up my reply but it all got reorganized when I clicked send post. I also see a typo so I'll try this another way. Use C5 as your input eg 33655.92Dr In D5 key in the formula =LEFT(C5,LEN(C5)-2) this will give you the raw value of...

Don't know if this'll help but it might: 33655.92Dr 33655.92 6 Dr 1 33,655.92 333655.92Dr =LEFT(C5,LEN(C5)-2)=LEN(D5)=RIGHT(C5,LEN(C5)-(E5))=IF(F5="Cr",-1,1)=+D5*G5

I guess it doesn't show what really happens. I am working on a report that has an account number in column a and then several lines further down it will have another. This goes on for several hundred lines. What I do manually that I would like to get into a macro is the following: I copy the...

Sub Macro1() ' ' Macro1 Macro ' This is a great function on a spreadsheet but in a macro ' it wants to go all the way down to cell 65536 which sort of ' negates the whole point of a macro’s speed Range("A4").Select Selection.End(xlDown).Select Range("B5:B338").Select...

Please! I just need a little help here...

I've never seen this before!! What a great idea and thanks for your help. http://hotfile.com/dl/123609701/e52d8b8/Example_for_Pointy_Haired_Dilbert_Forum.xls.html I have a number of notes in the file just in case they don't show up right off.

When I do that I get a Compile Error: Invalid use of Property When you say contiguous it sounds to me like you are trying to capture data around cell A3 - A3 is the cell in my range that will vary - I know it will go from wherever my cellpointer is to N800. Wouldn't a function like that stop...

I see my spacing didn't work the way I had hoped the 950.00 and the 9755.00 were supposed to show in col H and the 1 in Col N

1: I import a data sheet that I need to edit before posting it to another worksheet. When I import the data I insert a column which serves as a line counter. The imported data is usually skewed so I need to sort it out and this is where my problems start. The range I usually have to sort...