Recent content by Matt_g

And thank you for the list of excel constants too. They will come in handy will copying macros that have been recorded in excel.

Thank you so much - that makes perfect sense and it now works. It has been bugging me for 3 days now!

It errors on this line i think: ApXL.Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=$I$2=1"

Hi - It stops running the sub and I get an error in access saying "object doesn't support this property or method". The first 2 lines run ok - it is when it gets to the formatconditions part that it errors.

Error when using VBA to apply conditional formats on Excel Sheet (from Access) Good Morning. I am pushing some data to Excel from an Access query. When the data is in Excel I reformat the sheet by changing the fonts, applying borders and cell formats - I have got all of this to work fine...

Hello! I am a SAS Analyst based in Leicester who has been tasked with building a work request logging database in MS Access. when i am not working I am probably cycling. I have been using this forum for tips so far but now have a seemingly impossible problem!