Adjusting VBA code to go to first free cell down

**geri_n** · 12-21-2011, 05:28 AM

Hi all,

I write with the following problem: I wrote a VBA code in Excel but I cannot adjust some things and I will be grateful if you can help me. So, can be added to vba code to do the following:
1. Macros FillPrices - after filling data to go to first free cell to be ready for use next day.
2. Macros FillPrices - after filling data conditionanally formating in red if used formula (true condition of IF operator).
3. Macros FillIndices - after filling data to go to first free cell to be ready for use next day.

I attach an example file.

Thanks in advance.

**arlu1201** · 12-21-2011, 06:03 AM

I have a couple of questions -
1. Your file has several tabs. On which sheet should the macro go to the first free cell?
2. After going thru ur code, its apparent that you want the paste special function to be performed in certain sections of your file and there could be some other actions too. If you explain it to me, i can help you better your code.

**geri_n** · 12-21-2011, 06:08 AM

Hi Arlu,

My purpose is to change data in Buletin tab and run FillPrices macros to fill data in ten other tabs (without PAZAR sheet). For this 10 tabs is other purpose toconditionanally formating in red if used formula (true condition of IF operator).
2. Paste Special (in FillIndices macros) is for PAZAR sheet and this is related to my question 3.

**JBeaucaire** · 12-21-2011, 06:15 AM

For 1 & 2:

Please Login or Register  to view this content.

For #3, this will select the next empty row and confirm with you before proceeding:

Please Login or Register  to view this content.

**JBeaucaire** · 12-21-2011, 06:15 AM

If you want the FillPrices to automatically do all the sheets, try this:

Please Login or Register  to view this content.

**geri_n** · 12-21-2011, 08:19 AM

Your code looks good, but does not start with me and I'm not sure whether there were the settings but I can not check them.
Will it be many arrogantly on my part if I asked you to attach the file with your corrections

**JBeaucaire** · 12-21-2011, 01:22 PM

...but does not start with mean...

What are you asking here? I don't understand that.

You can copy my macros into your module to replace your macros, or change the name(s) of the macros and add them into a separate module to test separate from your original macros. You know which module I mean?