PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 [125] 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Relative selecting to the right (or left)?
  2. Merge multiple workbooks with multiple worksheets into one
  3. [SOLVED:] Update Cell Based Off TickBox Value
  4. The specified Dimension is not valid for the current chart type
  5. [SOLVED:] PLEASE HELP ME WITH MONTHVIEW
  6. Extra lines at the botom of notepad when opening CSV
  7. Select picture shapes
  8. skip zeros for chart range
  9. How to Convert XML text intoe Array
  10. Macro that updates a workbook using an old workbook
  11. Extracting a number from text using a vba function
  12. [SOLVED:] SQL Syntax help
  13. [SOLVED:] Unprotect a merged cell
  14. [SOLVED:] Run Crystal Report from Excel VBA
  15. [SOLVED:] Dynamic hyperlinks?
  16. What method do I use?
  17. [SOLVED:] Change VBA from AutoFill to FillDown
  18. Compare two sentences and highlight in different color
  19. [SOLVED:] VLookup Formula
  20. Trying to create Submit button that will attach the form created in Excel via Lotus
  21. [SOLVED:] exporting chart as image on a mac
  22. How can I see the code used on another form?
  23. [SOLVED:] Filter data to pages based on number format
  24. [SOLVED:] Two macro button but in a double action
  25. Vlookup from external file
  26. Please help - pivot drilldown macro
  27. how to set function( input range )and (array output)!!
  28. Code That Works on PC but not Mac
  29. Chart color palette sync issue
  30. Insert Image to Specific Page using APPWD
  31. [SOLVED:] Macro that copies data and format Worksheet to worksheet
  32. [SOLVED:] macro in excel
  33. IF function
  34. [SOLVED:] initialize all DTPicker same CustomFormat in UserForm
  35. Kick off macro when a cell is double clicked?
  36. Adding attachment to the lotus notes via evcel VBA
  37. [SOLVED:] *variable* in .AutoFilter Criteria
  38. [SOLVED:] searching a range alphabetically
  39. Variable column reference for a formula
  40. How to make the values in larger font for the cells with datavalidation?
  41. Refresh ribbon with code
  42. fixe through the win7 date windows and get information by retrun,!!!
  43. Workbook.Open Opens a Dialogue Box Instead of the Specified file
  44. defining a range as a string
  45. VBA to copy worksheet and insert at the end all worksheets
  46. How to move column?moving is possible,if so will it affect formulas?
  47. [SOLVED:] Protect spesific columns from deleting
  48. Excel 2010 VBA and Speech Recognition...
  49. Application-defined or Object-defined error
  50. IE automation - tricky - how to give the script a file path then click OK ?
  51. marco in Excel - loop probably
  52. How to disable Clipboard Section (Cut, Copy, Paste) under Home Tab - Excel 2007
  53. Need macro to update cell that linked to another program
  54. dual search criteria over two ranges (ie column)
  55. Need macro to check data from workbook to another workbook
  56. Macro which copy cells if other cell have specific value
  57. [SOLVED:] Beginner's attempt at VBA!! Not sure what is going on!!
  58. Save image from computer to worksheet via userform
  59. Read Only Files
  60. Excel and Word
  61. using pointer in VBA
  62. onAction refreshing ribbon macro
  63. inserting a pdf as ole object into word doc from excel
  64. [SOLVED:] Formula to calculate how many circles fit in a larger circle
  65. External reference help
  66. length of a minimum of a range defined by a variable
  67. I Need Help Vba Code Disable Key F12
  68. #Click in Botton of Web Site whith VBA Excel 2007
  69. [SOLVED:] excel vba to sum textbox values inside a userform frame
  70. Count if - cell color index & cell value (range of value)
  71. Open file from FTP: "Excel cannot access" error
  72. Dependent (conditional) combo box without creating UserForm
  73. [SOLVED:] go to worksheet depending on Cell value
  74. [SOLVED:] Change the range to all data range in column
  75. How can I speedUP my events based procedure?
  76. Copying data down the column til then "nth" row
  77. Filtering by InputBox date entries and using Autofilter with 3 criteria
  78. Sleeper: Nested if VBA
  79. Select Column with VBA and come up 3 rows from bottom
  80. Open and close multiple workbooks - out of memory
  81. Right click on the tab: Enable
  82. [SOLVED:] Surveys in Excel!
  83. VBA codes find multiple data using multiple criteria
  84. Choosing ranges/cells between sheets!
  85. Not Saving
  86. Organizing Data with many categories
  87. Runtime error 1004 - paste method of worksheet class failed
  88. [SOLVED:] Consolidate two reports based on multiple criteria
  89. Worksheet sheetchange -out of stack
  90. [SOLVED:] Difference between carriage return and linefeed?
  91. [SOLVED:] Problem wih logical es formula
  92. [SOLVED:] Sorting Simplification Problem
  93. [SOLVED:] Insert row and paste data into (modify code)
  94. [SOLVED:] Alert/Message Box
  95. Protect Range of columns
  96. Create a combobox
  97. vba macro splitting string/text
  98. How to grab particular data and output data?
  99. [SOLVED:] How to automatically rotate through task
  100. [SOLVED:] Find and copare value afte fill cell
  101. [VBA] Changing to directory with variable that was read from a text file
  102. Workbook Not Saving
  103. [SOLVED:] if find less that six numeric value clean the cell
  104. Search folder -> find excel in folder and copy data
  105. [SOLVED:] Writing formula at the end of selection
  106. Using R1C1 formula referencing other WB and SH
  107. [SOLVED:] VBA Formual not working
  108. [SOLVED:] Conditional Formating (modify)
  109. Automate Report
  110. Buttons often expand to fill the worksheet. Button Bug
  111. [SOLVED:] Copy multiple cells on the same worksheet after a search
  112. Get data from HTML files
  113. [SOLVED:] vba module not reading the IF Statement
  114. [SOLVED:] deleting old ws (cycling sheets)
  115. [SOLVED:] Interactive userform please help
  116. [SOLVED:] propertrim() and lower() functions, manipulating ranges of cells
  117. Rename Picture to Value in a Cell & Copy to Worksheet
  118. [SOLVED:] VBA macro help to find index match error
  119. Analysing a Word Documents headings and write it in an array
  120. [SOLVED:] Adding Page breaks every ninth row
  121. [SOLVED:] Extract data between brackets
  122. Minor Flaw - Help and understanding required if possible
  123. One Checkbox to uncheck/disable all others in group
  124. Select last cell with the data in the column/range of cells - only visible datas
  125. [SOLVED:] Worksheet change help please
  126. Clean the Cells if cell does not start with (
  127. [SLEEPER:] Automatic Deleting complete excel sheet in 2 years
  128. [SOLVED:] Change cell color based on text
  129. Error: You must rely on system font, Adobe 10, windows 7, Office 2010
  130. Help need to fix code
  131. Find all values with curly brackets
  132. VBA syntax error
  133. Need help seperating files
  134. [SOLVED:] Cells blocked with permission to change II (block full range)
  135. [SOLVED:] VBA code that Unhides sheets that are hidden using sht.Visible = xlSheetVeryHidden
  136. vlookup on an array
  137. Excel 2007 Code
  138. Need Help on a macro...kind of desperate!
  139. [SOLVED:] Copy interior Color to linked Worksheet
  140. Need Help: Macro that can filter data and plot results on a matrix
  141. [SOLVED:] Extract unique Values by comparing Master list and copy full row to another sheet
  142. Simple macro - loop to write value from column to another cell, then save as PDF
  143. creating report
  144. [SOLVED:] Macro to match entries in column A on diff sheets
  145. [SOLVED:] Compare sheets macro
  146. Find particular text in a sentence in a cell and copy to adjacent cell
  147. Pick specific portions and make new lines
  148. word doc with multiple tables to master excel spreadsheet
  149. Sleeper: Creating Row and Column headers based on a formula and filling with formulas
  150. [SOLVED:] Increase Target.Value By Percentage
  151. Move / copy to relevant cell matched with sheet name VBA excel 2010
  152. [SOLVED:] Printing only non-blank rows
  153. [SOLVED:] VBA Query to filter #N/A
  154. [SOLVED:] VBA to populate a multicolumn listBox using Additem
  155. To Sum all columns to right
  156. [SOLVED:] Unqualified Error
  157. [SOLVED:] How to get Tab-index from user form in ascending order
  158. [SOLVED:] If variable 1 = 'this' then make variable 2 = 'that'
  159. How to Skip a column for every 2 columns while Paste the values?
  160. Need VBA coding help for status bar and screenupdating
  161. (Bit Rusty, Need Help) Copy & Paste for Adjustable Cell Range (Horizontal to Stacked)
  162. Can some one help on Saving multiple excel files from one excel data file
  163. text to number
  164. Late Binding VBIDE
  165. AppActivate does not work
  166. [SOLVED:] Multiple Criteria Duplicates
  167. Need Help with Macro
  168. Excel VBA for ammending outlook Signature template
  169. Query Connections on a Mac
  170. Dynamic Named Range used on multiple sheets
  171. [SOLVED:] append several sheets to a 'Results' sheet
  172. [SOLVED:] VBA to lock specific rows when a worksheet opens
  173. [SOLVED:] Date keeps returning time, don't understand why
  174. Send Keystrokes Without Interrupting The User?? - There has to be a way
  175. Cannot Insert Image into Mac Excel 2011 UserForm
  176. [SLEEPER:] mousemove(drag and drop) for spreadsheet on vba userform
  177. Maximum x-axis value of chart couldn't fit into the image control of userform
  178. Customer-Data Tally work sheet Update Using VBA
  179. [SOLVED:] Command execution VBA
  180. Problem solved? HLOOKUP/VLOOKUP question.
  181. Output Unique Data To An Array VBA
  182. How to sort invocied by column based on sequence number provided in another sheet
  183. [SOLVED:] Adding Number into the generated Report
  184. [SOLVED:] Insert after
  185. [SOLVED:] How to insert rows in sheet1 based on sequence number.
  186. [SOLVED:] Make macro timer a little bit more fancy
  187. [SOLVED:] Custom function not being able to record correct cell values - RANDOMLY???
  188. [SOLVED:] Copy and paste data and format if values match between sheets
  189. Modifying codes to add if-else statement
  190. [SOLVED:] Listbox default tem when the list is made up of dates
  191. Moving Rows Reversing Columns by VBA
  192. VLOOKUP referencing table name
  193. Need to calculate sum & division till end of data in sheet1
  194. [SOLVED:] Using DropDown list to navigate through Sheets - Help with Code size reduction
  195. Fill sheet 2 with details as froma table in sheet 1
  196. [SOLVED:] vba to generate XML file with different values
  197. [SOLVED:] AUTOMATIC ROW NUMBER GENERATOR
  198. Pivot table format
  199. [SOLVED:] formulaArray resultat over Msgbox
  200. Changing cell value from another workbook cell value in vba macro
  201. Sleeper: Run time error 1004 file could not open
  202. Pivot table priority issue
  203. Optimize VBA code
  204. VBA Automatic Data Export from .Docx to Excel
  205. Code takes action on multiple worksheets
  206. [SOLVED:] CONCATENATE used with IF AND funtion
  207. VBA code to transfer data to different workbooks
  208. macro to control visible tabs
  209. Most efficient way to copy array data (big amount of data) to a txt file
  210. [SLEEPER:] Pivot Table - Hide Columns + Maintain Grand Total
  211. Macro/VBA to remove all text before hypens - Active X Combo Box
  212. VBA Help, need this for school
  213. Runtime error 1004
  214. VBA- copy/union certain cells
  215. Moving Duplicate records from one worksheet to another
  216. [SOLVED:] Reformat Spreadsheet
  217. Measure height of textbox
  218. [SOLVED:] Macro that sorts a specific column by colors and value.
  219. Fill Down Data
  220. Case When error for set values
  221. Custom button sometimes won't load to ribbon through xml
  222. [SOLVED:] Help using Named Range in VBA tp pupultate a worksheet.
  223. (*Challenging!*) Protect two range's data validation and change in priority order
  224. Fetch the data's from excel file and provide the CSV file as a output
  225. Save a file as csv with date
  226. Computing Limitations for large VBA code
  227. Select multiple cells in a range
  228. [SOLVED:] have to delete one to one duplicate entry in muliple columns
  229. [SOLVED:] List all Excel and Word files in a folder containing specific text
  230. Challenging issue when making alignment of datas into excel using vba
  231. Sleeper: Creation macros
  232. With 2 sheets, if value not in one sheet AND column C = specific color, copy & Insert
  233. [SOLVED:] Disable Send by Email
  234. ScaleAxes with VBA problem
  235. [SOLVED:] How to use vba fuction to translate the day format
  236. select cells through loop
  237. Need Help with Querying an Excel Table in VBA. ADO?
  238. Macro to copy data from one workbook to another.
  239. [SOLVED:] Out of memory for below code
  240. [SOLVED:] Wrapper for RtlMoveMemory
  241. [SOLVED:] Subtotals several columns
  242. Date Filtering with VBA
  243. Document select, and move
  244. Hide Rows to variable specific criteria
  245. When PrintView button is clicked open the invoice in PDF format
  246. [SOLVED:] Insert Picture in Footer
  247. [SOLVED:] Get Max value in a multpile term cell reference
  248. User Form Code to Load Text Files
  249. [SOLVED:] Copy Data from one sheet to another IF cells are highlighted specific colors.
  250. [SOLVED:] Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color.