Search results for query: *

I've struggled with using vlookups in vba code for a while now and I have only just found the solution (thanks to skipvought from this thread - thread707-1022186) so I hope this helps. I've looked at loads of threads on this subject and the problem always seems to be same. The error message...

No major issue. I'm currently doing something similar. I was trying to get this to work with the minimum of code and without extra sheets if possible. I thought I would be able to just tell the graph how many points I want on the x axis. I guess there is no other way though. Thanks for your help.

I think that's what i'm trying to get around. It's a graph of age groups and numbers of people in each age group. I want the x axis to show ages 1 to 100 and there are only 55 age groups in my data so it's putting points 1 to 55 on the x axis. I want to include an age group even if there is no...

Sorry I re read my question and it's not very clear. I actually want the amount to go from 1 to 100 eventually. It's a chart that is created by a macro and I want to find a way of entering the values 1 to 100 other than typing them all out. I figure there is probably a way of writing something...

I want to this to display 1 2 3 4 5 6 7 8 9 10 etc. The only way I can do this is to enter "={1, 2, 3, 4, 5, 6, 7, 8, 9, 10}". Is there a way of writing something like ={1 to 10)? Nothing I can think of is working?

Thanks mrmovie. I wanted to make sure I wasn't missing something really obvious. I have tried using collections and For Each loops but I struggle with them. I can eventually get them to work after lots of trial and error but it's the theory and programming conventions behind them that I don't...

I know. My question was "is there an equivalent function in VBA or just a better way of performing the same action?

I often use the following code to move through rows on a spreadsheet, executing some other code at each row, and was wondering if there is a more simple or established way of performing this (not that it's that complicated). Employee_Row = Employee_Row + 1 Cells(Employee_Row, 1).blah blah blah...

Thanks for pointing me to that thread I appreciate it and it has solved my problem, I did search but people tend to ask questions like "HELP!!!!!!!?" rather than "Is Workbook Open?". Most the the results of my searching brought up threads that contained huge sections of code that solved the...

Is there a simple way of determining if a workbook is open? I'm looking for something like this: If Workbooks("Provider Rates.xls").IsOpen = True Then ProviderRatesCloseButton.Enabled = True Else ProviderRatesCloseButton.Enabled = False End If

Thanks Roy The first thing I did was to click on FAQ's but all this showed me was about 5 FAQ's mainly based on Excel and/or VBA. I'm afraid in my techno-numptiness I don't know how to find a directory of all the FAQ's available. Further to my techno-numpty state of ignorance I hadn't thought...

This is a newbie question. I have created a report that displays Employee number, Name and age. The age is calculated using the DateDiff expression. I want to sort the report on this Age field (It's a text box) and isolote staff over 65. I assume I do this by writing an expression in the...

Is it possible to share a subfolder in outlook? I have my own calender with personal items in and I want to add a subfolder to this with meetings and work related items to be shared with a number of collegues. If I do this no-one can select to view the subfolder, only the main calender...

Thanks guys. Most helpfull - I would have been stuck on this for a long time on my own. Chris.

Sorry Tony I didn't explain clearly. This is a new query but I included it in this thread because you guys obviously new your stuff on this subject. My query about 'seconds' has been answered - both yours and Loomah's methods work fine. I'm now trying to format the times the phone calls were...

To be honest I just put the formula in to the code as it was z = 0 For x = 1 To ItemCount z = z + 1 Cells(6 + z, 5) = "=TIME(TRUNC(" & Cells(6 + z, 4) & "/3600),TRUNC(" & Cells(6 + z, 4) & "/60)-(TRUNC(" & Cells(6 + z, 4) & "/3600)*60),MOD(" &...

Thanks Loomah I thought there probably would be a way to do it with a formula but I had no idea how. Chris.

I'm trying to convert mobile phone call times from seconds to minutes. E.g. I have a cell containing the value 169 - this being 2 minutes 49 seconds. How can I convert this to hh:mm:ss or even just mm:ss? Thanks

Thanks guys. That works perfectly!

I'm trying to check the first character of each cell in a given range. I've tried declaring the variable 'z' as a range but I get the error message "Object required". Any ideas? 'Insert the DivisionTypes DivisionTypeRange = Range("B" & CurrentCellRow - ItemCount, "B" &...