Columns(SelectedHeaderColumn).Select For Each Entry In Selection $currentsheet->Columns($SelectedHeaderColumn)->{Select}; #this is okay and does what it is suposed to, select the right column #here comes the problem: this is one example how I tried it my $selection = $currentsheet->Selection; foreach my $Line (in $selection){