activecell.offseti

Hello, I have a piece of code that I have used successfully many times going through different ranges in excel (mainly containing charts) and pasting theme into powerpoint as images. Now I need to do the same but paste the charts as chart objects instead. Any tips? * Sub open_ppt() Dim...

Hi there, Im getting a runtime error 91 in VBA and cant figure out where the probelm is. I've used this code before and now its not working Sub Macro2() ' Defines variables Dim InputFile As Workbook Dim OutputFile As Workbook ' Open input / output workbooks: With...

So What I need to do is copy and paste the values from the green columns in workbook 1 into workbook 2 if its says "yes" in the last column. I then need to cycle to the next row in workbook 1 and paste the values into a NEW worksheet in workbook 2 and do the same until it no longer says yes in...

Hello all you VBA gods! I am new to this forum and new to VBA as well. I am trying to code a spreadsheet for work and, of course, I have bitten off more than I can chew but on the upside, I am learning quite a bit about VBA! I have this tricky problem.... I am trying to select every 'nth' cell...