Hello,
I'm trying to Select column M if my String = AETD or FBR, but the macro always uses the Else statement even when the variable is = AETD or FBR.
This leads me to believe that there is a formatting issue with the first line in the if statement. Anyone know what's wrong?
Please Login or Register to view this content.
The expression in the If statement looks fine to me, are you sure there are no trailing/leading spaces in the cell(s) you are trying to check, or some other problem with the data?
If posting code please use code tags, see here.
Cell A1 is formatted as a text cell, meaning there is a ' in front of the cell value. Also A1 has conditional formatting so that you can select the value from a drop down list. Would any of these cause the code to not recognize the value?
Also worth mentioning that the MsgBox returns AETD or FBR with no ' before the value, and the if statement still doesn't run correctly.
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
The Worksheet in Basis(1) file is the raw data. The VBA is all in the .xlsm file > FormattingMacro module. Use Format and Save button to test. 'it wont actually save
When I step through the code it's Columns("M:M").Select that's highlighted in this section not the Else part, Columns("H:H").Select.
That indicates that the expression in the If statement has evaluated to True, ie Program = 'AETD' or 'FBR'.Please Login or Register to view this content.
Interesting. If the code is selecting Column M, why is it pasting Column H into the new sheet?
EDIT: Actually it's pasting Column I into the new sheet.
Last edited by BryceVBA; 03-23-2017 at 01:07 PM.
What happens if you change the code to this?
That explicitly states which column to copy (and which sheet/workbook it's in too) so you aren't relying on Selection.Please Login or Register to view this content.
Still paste column I into sheet2
Please Login or Register to view this content.
Which column from which worksheet in which workbook do you want to paste into a new worksheet?
Also, which workbook are you adding the new sheet to?
PS I'm assuming you are working with 2 workbooks.
Except for determining variables, the whole macro is ran in the raw data wb (Worksheet in Basis(1)). I'm trying to paste column M in sheet1 to column A of Sheet2 (the macro inserts sheet2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks