Search results

Ha, two hours lost :). I was screwing around with offset but couldn't work it. I did change the For x = Range("A1:A" & Range TO...For x = Range("A2:A" & Range but couldn't debug it. Glad I'm not really working! Thanks. How do you know all of these things?! JHalm (Jdubs)

Option Explicit Hello, a few weeks ago asked for code that would to delete rows for any cells that are <>5. The code worked famously with one exception...The Header Row in Row 1 (Column Titles) are wiped out when I use the code. I've been trying for a few hours today to fix it to no...

But can I get a job if I have the CMA but without manufacturing experience

Thanks Fred. I have to say there are more CMA advertisements than there is for CPAs, MBA, etc. Do I need manufacturing experience?? I don't have any. However, I really liked the course Management Accounting course. How cab I bridge the gap, if needed? Oh yeah, thanks for the great replies ;)

Hello everyone/anyone...I'm trying to find a certification as a Financial Analyst (more like Sr. Financial Analyst). I have an MBA in Finance but the job market is so slow I'm not having any success. I do not want to go for the CFA. I'm a little to old for the longer work days and have a...

Hi everyone, another afternoon trying to work a little sub routine. I have 12,000 rows with values from 1 to 11. I would like to sort column A and delete all rows <> "5" (the vlue of 5). Below is a sub I copied out of Mr. Excel but I was unable to get it to work. The sort was not...

Thanks Luke, that's perfect

Hello friends, I am working a spreadsheet and need assistance to delete rows. My spreadsheet contains approximately 750 rows and 5 columns of data. Column A contains accounting lines that has this format (PJE012525, or PNE035757,etc.). The majority of numbers are unique. However, there are...

Wow, that worked wonderfully. That will be extremely valuable down the road. Thanks so much for your knowledge and patience. JH (J-dubs)

So Sorry Luke. I'm afraid I may be flustering you. Maybe I can explain it better. My data set is comprised of approximately 48 colums and 10,500 rows. Columns A and B are essentially small project construction projects. Column A indicates the type of construction (A, B, C, F, N, etc.)...

Hi Luke...please see the partial spreadsheet and code. RWA Type RWA Number RWA Number Org Code N 1156597 N1156597 P0525172 N 3577941 N3577941 P0573000 N 3063934 N3063934 P0525223 N 2842185 N2842185 P0525223 N 3664812 N3664812 P0574000 A 2835406 A2835406 P0520001 N 2615765 N2615765...

Hello, I was having a problem yesterday when I tried to use VBA to counta all cells (no empties). Every time I download to Excel I will have different quatities of Rows...somewhere between 9,500 and 11,000 Rows. I am using the Range Selection up to select all cells above. I would like to use...