tag:blogger.com,1999:blog-3739525582411091001.post6678123407416885652..comments2023-06-11T05:14:03.949-07:00Comments on SharePoint Served: Remove User ID of a People and Group column when exporting SharePoint list to ExcelPrasathhttp://www.blogger.com/profile/06697356352311369520noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3739525582411091001.post-66153253196915172772016-08-17T09:26:45.249-07:002016-08-17T09:26:45.249-07:00Great. Thanks for sharing.Great. Thanks for sharing.Prasathhttps://www.blogger.com/profile/06697356352311369520noreply@blogger.comtag:blogger.com,1999:blog-3739525582411091001.post-9543833501050140682016-08-17T08:25:44.017-07:002016-08-17T08:25:44.017-07:00One issue I found is an error in the line:
For co...One issue I found is an error in the line: <br /><b>For col = start_of_range To ActiveSheet.UsedRange.Columns.Count</b><br /><br />The looping through columns starts at the value set in <b>start_of_range</b> (which is the first ROW, I believe, in this case 2 so that it skips the header row) rather than <b>column_start</b> which is the variable defined for that purpose.<br /><br />So changing that line to <br /><b>For col = column_start To ActiveSheet.UsedRange.Columns.Count</b><br />fixes it.<br /><br />In my case, I only wanted one column, so I actually just tweaked it to<br /><b>For col = column_start To column_start</b><br />although with some small tweaking, you could remove the loop altogether. I opted to leave it in because it was a faster change and in case I want it over multiple columns in the future. Although I might set a <b>column_end</b> value instead of presuming it's supposed to go to the end of the spreadsheet.<br /><br />Ken Marablehttps://www.blogger.com/profile/11657351442353880984noreply@blogger.comtag:blogger.com,1999:blog-3739525582411091001.post-11284292828646300562015-09-16T08:23:36.440-07:002015-09-16T08:23:36.440-07:00Hi, thanks for this post. I am not sure if anyone ...Hi, thanks for this post. I am not sure if anyone is still following the blog, but how do I change this macro to end at the 7th column? It runs across all of my columns and deletes numbers in my date fields. <br /><br />Thanks!Anonymousnoreply@blogger.com