I finally got this to work. Here is the code I used. Dim oSheet As Object oSheet = thisComponent.getSheets.getByIndex( 1 ) rem --- source for feedback Dim oRange As New com.sun.star.table.CellRangeAddress oRange.Sheet = 1 oRange.StartColumn = SourceColumn oRange.StartRow = 0 oRange.EndColumn = Sourc...

Oh, forgot to say that the version of OpenOffice I am using is 3.3.0
This is a work computer and I have asked if we have access to a later version
and will update if I get an answer to that.

thx,

dennis

I was able to create a macro myself to get what I needed done.
This can set to resolved but I am not sure how to do that.

dennis

[solved] Hello. I am in need of some help please. Being new here and not really a programmer, what I want to do I think is really simple. Really don't understand why it does not work. In Calc, I have 12 sheets. The source sheet is sheet 1 (with the first sheet being 0 as I have learned) that has col...

Hello. I am in need of some help please. Being new here and not really a programmer, what I want to do I think is really simple. Really don't understand why it does not work. In Calc, I have 12 sheets. The source sheet is sheet 1 (with the first sheet being 0 as I have learned) that has columns from...

Thank you, thank you. That is really good idea and I will work on adding that. I have no one else in the office that can help with this so it's a learn as you go project.

Dennis

Hello all. I have a very basic newbie question please. Working in calc and been creating a macro. I have a loop setup that creates new sheets which seems to be working. There are up to 20 columns that will have different text in each row. For example: B1 would have Tom, C1 would have David, D1 would...

Thank you for the tips. Those links seem to be what I am looking for and will get me started. It's really appreciated.

I do not have nor can I hire a professional, but thank you for at replying.

Hello all. I have searched and not really found what I was looking for. There is a need at my work to automat a spreadsheet and I hope it's not too complicated. We have date that is exported out with a list on Student names in Sheet 1. I need a way to create additional sheets with the name of each s...