Search results

wah'll the vba is so clean and crisp...thanks

sure...

Does anyone now how to background shade every other alpha character in a column, I have sorted rows of data on one column which contain just single variable amounts of alpha chars A<>Z I found this code and thought I might tweek it, but I find its a little to Cumbersometo adapt to suit my...

Thanks for your response, I am working 12hr shifts at the mo ,so no time to test or upload ,but I am really really greatful for your response, i will do a,s,a Thanks

I have a few questions to your code re - just replace MsgBox "It's working!", vbInformation with my code I tried using call RDB_Workbook_To_PDF but nothing happened, is there a way, or am I just not calling the sub properly, as i'd like to call 2X subs, the other would call another sub to save...

Your a champ, this has been bugging me for months. Will give it a go and thanks for the info links.

many thanks, and as always works a treat. I had a rather long winded approach below, but I learned a few things on the way :) Public Sub SelectFirstBlankCellBB() ' this vba selects each blankkC row as it steps through the For loop in Column F 'then when it finds a blank it it copies the...

Hi, Is there a way to Automate and achieve my goal, save to pdf and overwrite on every single change?

Hi, So is there no way to automate/achieve the outcome I am after then? thanks

upload sample sheet one is what I have so far and sheet 2 is what I'd like Thanks guys and girls ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

I think I almost have it, if anyone can help tidy this up, the only thing is it gets the session time above the wrong session, so I am lost on this part...Many thanks in advance if anyone out there is listening The below Vba stops at each blank row as it steps through the For loop in Column F...

So that all said in english is: Goto the first block in column and take the first cell value from column F and copy or store the value then move the line above and move 2X cells to the left and add the word "Session time = " & cell_value (possibly merging ,formatting bordering the 2X cells...

Hi, And thanks for taking the time to look :) I have a spreadsheet with one column... (F) that contains various different session times for each person for any given day. So for the first session I may have 20 peoples names attending on each row with the session time, (I already have the vba...

Thanks, for your suggestions, I did try recording a macro, but the "Daily_extracted_datasheet098230928348.csv" that I record a macro on will have a different number appended to it each time it is ran even if its on the same day, so the worksheet change event somehow doesn't work and doesn't run...

Does anyone know the best way. To automate this vba. As i said in an earlier post i cant have my user s paste code every morning. Most are not pc savi. And just have difficulty finding and running a crystal report and extracting to csv format. And running a shortcut key on the keyboard. So i...

Yep. I hear you. But i do need the worsheet to save on every change to a pdf. As i need other people supervisors to ne able to see the last recorded times in real-time via the saved Pdf And please also before you suggest.i dont wish to share the workbook ...also if the user closes without saving...

Yes, sorry But I need it to save on every change Unfortunately. I am trying to automate the vba on a new Daily downloaded worksheet. So can.t tell users to paste every day...thanks for your suggestion though

So Sorry, but I actually need it to save to a pdf with every change and overwrite. Thanks on advance and do you any suggestions for this.

I need help with the coding part of autosave to Pdf if any changes occurs on on a worksheet and also to overwrite the newly created existing pdf , I managed to find vba to save save pdf (via WWW-Google) as below Sub RDB_Workbook_To_PDF1() 'Stop Dim filename As String...

many thanks, just what i needed

I have a csv file that I need vba code to search through two specific columns row by row (I & J): and if an exact match found delete the entire row So far I have long winded VBA that almost works, but unfortunately it only looks at one specific ie: column( J) at the moment, So what i need is...

Well done and thank you so much for all your efforts, for what you have done with this issue although it's not completley solved. You have managed to take it way past my expectations of what I thought could be done with the problem. Ultimately though, I have to say if it doesn't work properly...

Hi, firstly thanks, I tried running as you suggested the code a second time around, but nothing happens. I guess it's because if it didn't find the first time around then it won't find any more swaps, No matter how many times I try, yet there was clearly one other available a 2X way or 3Xway...

Hi, Have you managed to step through the code in the file I attached...cheers