Palo Community Forum

Hi Pommie,

pls. check:

Open your file
Select D11
Press the copy button
Select D13
Click Escape (!)

I get an errormessage: "Target Range contains no palo.data formulae - pls reselect."

This happens only on the FIRST run of the macro. Maybe there's something wrong with (global) variables.

I do this on your original file.

Something else:
To test I disabled the check for multiple ranges selections. It works perfectly for multiple ranges. When I select a range outside the report nothing happens and I get an error message, perfect! You are looping through the range with "for each CELL in range" - so what is the trouble with selecting multiple ranges??? If I select correct cells and cells with subtotals (that would require splashing) then the input cells receive the value and the others nothing - like it happens if I select a single range - perfect!

arno

I cannot solve this. The code of Sub GetRange() never reaches "End With" when I do not click "ok".

"Hello World" never shows up when I press escape:

Sub GetRange()
With Application
.DisplayAlerts = False
Set rRange = .InputBox(Prompt:= _
"Please select a single range with your mouse", _
Title:="Please Specify Target Range", Type:=
.DisplayAlerts = True
End With
MsgBox ("hello world") '<================================
etc.

EDIT1:
If I add "On error resume next" in GetRange then it works. (But I do not know what else could happen)

EDIT2:
If I first select a target range without pale formulae and press "OK" then I MUST paste the values somewhere as I cannot get out of the loop by pressing esc.

Hello Pommie,

I would like to implement the PaloCopy function into an existing workbook. However, the code does not work when I enter a single range with more than one cell as a target (it works with one cell).

The problem is that the inputbox does not supply a range, if I disable On Error resume next I will get error 424 "object required" because rRange remains Nothing in line

Set rRange = .InputBox(Prompt:= _
"Please select a single range with your mouse", _
Title:="Please Specify Target Range", Type:=

I created new workbooks and added the palocopy makro to them without problems.

The problema appears only in the sheet that consists of formulae only (it has not been created with Palo paste view), the other sheets work. Could it be that some Palo-events interfere with the inputbox?

When testing, the code works if I replace the inputbox with some named range like
Set rRange = Range("here")
So, I'd guess that the inputbox has a problem.

At some point the Palo addin does not work anymore, eg. the datac-formula is lost when I enter some data that should be written into the cube.

So far, I could not reproduce the problem in another file, however, palo paste view appears to be active all the time, I could not break the link.

I think I will have to recreate the workbook, however, I do not see why the problem with palocopy/inputbox should not happen again.

Regards

arno

So far, I found only one workaround - one makro to copy the value, select the target cells with mouse, makro to paste like:

Sub myCopy()
Range("IV1").Value = Selection.Value
End Sub

Sub myPaste()
Dim myR As Range
Set myR = Selection
sSourceValue = Range("IV1").Value
For Each rCell In myR
'.... your paste code here
Next rCell
End Sub

So, I simply avoid an inputbox (that does not work in the makros above, too!).

arno