Posts by Reafidy

Re: inventory spreadsheet

Post your workbook so we can see the formulas you are using.

Re: could you please tell me what you think about this bike

Perhaps you would have more luck posting in a bike forum.

Re: VBA Macro Code To Change Password To Protect The VBE

Thanks Simon.

Marreco, Please read the link in my signature regarding cross-posting before posting again.

Re: Change Case

Roy, were you intending to disable events in your code?

Re: Change Case

It may be your worksheet change event causing the issue. Whenever a cell is changed in the range M2:BB1000

Re: VBA: Paste Special (Values)

Matt,

Please use code tags for all code. I have added them for you this time.

Re: Convert a column number to a column letter

Lets try again here guys.

PersonHere,

Jindon has suggested you check the help file for the address property. This is a perfectly reasonable suggestion and you should do the same for the replace function. If you still don't understand then please be more specific about what you don't understand or why the suggestion didn't help.

Re: Create a macro to move data from one spreadsheet to another

You should have a go yourself and then post when you get stuck. As you say there are many examples here at ozgrid to help.

It doesn't matter if its a big blundering mess to start with, just give it a go.

What have you tried?

Re: VBA to name a dynamic range

GPSPOW,

Please use code tags for all code. I have added them for you this time.

Re: Paste to Next empty cell in new workbook

You need to fully qualify all your ranges. Including the active workbook.

Also it helps if we can know the exact line your code errors on.

Re: "Out of Memory" Error

Please read the link in my signature regarding cross-posting. Cross-posting without providing a link is against the forum rules.

http://www.mrexcel.com/forum/showthread.php?t=615831

Re: "Out of Memory" Error

If you step through the code, what line throws the error?

Looks like Jindons code to me.

Re: Vba insert duplicate lines of data based on cell value and list from external she

Nice coding Jindon, top effort.

Re: Change a String to Uppercase if it Exists - VBA

whatsup99,

Please read the link in my signature regarding cross-posting.

Cross-posting without providing a link is against the forum rules.

http://stackoverflow.com/quest…ppercase-if-it-exists-vba

Re: Macro needed

Thread titles are very important at Ozgrid, they help others searching for a similar problem. Please edit your thread title to correctly reflect your question.

Re: Login/Password Prompt for Multiple Users assigning different startup worksheets

It will be more complicated than you think. The main problem is that someone can easily disable macros which leaves the last sheet used displayed from when the user last saved.

Have a look here: http://www.ozgrid.com/forum/sh…7&highlight=enable+macros

In that thread is a file a provided to encourage users to enable macros by only displaying a splash screen if they fail to do so. This will be your starting point. We will then need to work on the login.

Re: VBA, UniqueList, Find, offset value, Concantenate

LucyLoo,

Please use code tags when posting code like this: [noparse]

Your Code Here

[/noparse] Alteratively use the code tag button # on the toolbar.

I have edited your existing post for you this time.

Re: Login/Password Prompt for Multiple Users assigning different startup worksheets

So what's your actual question, which part do you need help with and what have you tried?

Re: VBA - Copy Range Rows/Column Based on Macro Start Positions

ExcelInNeed,

Your comment above was an unfair judgement and your reported post was unnecessary.

Firstly your thread at ExcelForum was posted with a different format, explanation and code sample. It is no wonder you got a quicker solution.

Please note that Cross posting without providing a link is against forum rules. Please refrain from doing so in the future or be sure to post a link to the other website where you have submitted your question.

Also, you need to be a little more forgiving when using on-line forums. Smallman was not stating he doesn't care about you or your question, he was simply saying that the means of the raw data was irrelevant to him and to solving the question.

He indeed was trying to help you and gave his free time to do so, if I was in your shoes I would be most grateful.

Re: Help!!!! Inteligence needed!!!

Please be mindful of thread titles in the future, thread titles help others searching for similar problems.