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

  1. data from all the html files in an excel
  2. Prefix with "-" sign
  3. Solved: Fully clearing the used range of a worksheet
  4. code error going from xls 2000 to 2007
  5. Solved: Formula For based on blanks
  6. Solved: Count highlighted rows
  7. Change Tracking - possible without custom views?
  8. Need to reference multiple workbooks
  9. Get Key
  10. save as
  11. Solved: combobox populate
  12. VBA codes for skipping cells
  13. Solved: Compile Error of Duplicate Decleration in Current Scope
  14. find duplicates with different data and extract it
  15. Create New Workbook from existing Tab
  16. Solved: Find value, input into a different column
  17. VBA-PERL via .bat
  18. Solved: Importing a .txt file without a user prompt
  19. Multiple Page Print Form
  20. Lots of small queries in a small database - performance problems
  21. Remove string before a certain character
  22. HTML save not working
  23. Help with VBA Excel project please!
  24. Solved: Remember Hidden State
  25. Change font for part of a cell
  26. Combining Multiple Workbooks / Worksheets
  27. Button Image
  28. Solved: save problem
  29. Controlling the number formats in a file
  30. VBA Forms Module Help please.
  31. EnableOutlining problem - It is driving me mad!!
  32. Solved: show very hidden
  33. application not visible flashes
  34. Help with small project for work please
  35. Looking for VBA algorithm for circular references
  36. VBA Excel macros
  37. Create PDF Stopped Working.... Help!
  38. User Form /COMBO BOX 1
  39. Solved: Workbook_Open loop??
  40. Solved: VBA Reference Protected Workbook
  41. Solved: go to vb studio?
  42. Solved: textbox line under the text
  43. Solved: Auto Unique List
  44. Userform to edit records in different sheets
  45. I would like code to show active workbook
  46. Solved: Specifying file location in a cell and referencing to that cell in VBA, ASCII of 0 to
  47. Solved: help with the first program
  48. Avoiding Variants
  49. Excel exported reports have problem
  50. Adding a column to highlight the changes while comparing two version of excel sheet
  51. Solved: Sum if or sumproduct help?!
  52. Solved: values in range
  53. Copying Autofiltered data, pasting all data when autofilter shows no data
  54. Solved: Create dynamic range to use in formula
  55. Hide rows with bold text
  56. Perform action only if mutiple criteria is met
  57. Solved: call windows printers
  58. Sending Email in Excel
  59. VLOOKUP in VBA
  60. Combining mutiple excel files
  61. Copying certain cell on condition
  62. Searching many sheets for data
  63. Using name manager
  64. Solved: displaying certain line of text from notepad
  65. displaying certain line of text from notepad
  66. Trouble with Grouping
  67. Solved: ListBox1.RowSource for visible Rows.
  68. copy cells from one sheet to another
  69. moving folders based on a criteria
  70. Text To Columns VBA
  71. Solved: Form run time
  72. Creating Text Files from excel each row
  73. HOW TO OPEN EXCEL ADD-INS IN TO VIEW CODES
  74. VBA Coding: Font Change
  75. export worksheet to a txt file
  76. Copy rows to new tabs based on value in 1st column
  77. Solved: Cut and Paste cell value between 2columns based on criteria
  78. VBA code for comparing a worksheet with a column and show the result with a color
  79. QR Codes for Excel 2003 XP
  80. insert range of cells if data in column doesn't match
  81. Copy and Paste Problem
  82. Workbook_BeforeSave
  83. Solved: VBA to auto email report
  84. run macro automatically based on criteria in other spreadsheet
  85. Fixed/non volatile date function
  86. Copy between sheets
  87. Solved: average offset rows in a column
  88. Macro to update Sheet2 based on Sheet1
  89. Indentify column references for cells that meet criteria and assign them to variable
  90. Solver VBA reference in non-english Excel
  91. Solved: textbox focus
  92. combobox one last push
  93. create log for entire file
  94. Solved: I have exceeded Excel’s limit of 1048576 rows while importing data from a file
  95. Timeformat Sum Up and Separation Based on Conditions
  96. Cell reference copy in another cell without link and formula
  97. Object required error with VBA rows deleting
  98. Formula solution for repeated search in column
  99. Solved: Copy selected range in autofilter
  100. Insert the name of the worksheet in cell and than link the cell to another worksheet
  101. Count If
  102. Update powerpoint from excel macro
  103. Excel VBA Macro Crashing
  104. Solved: if & vlookup formula : help requried
  105. Disable alert message
  106. pulling data from multiple worksheets
  107. Select Case Function
  108. problem inserting formula with R1C1
  109. Run Time Error 7
  110. UserForm_Terminate
  111. Sub / Function recorder
  112. New project
  113. Spreadsheet data management
  114. Solved: Find and Replace for Time
  115. Do Loop with InputBox and ActiveCell Ref HELP!!
  116. Solved: AutoFill TextBox in UserForm
  117. Highlighting Cell in Variant
  118. Solved: web navigation
  119. looking for an Event that fires when an existing Workbook is opened
  120. Opening Excel file and running macro
  121. How to save filename with -v2 -v3 and so on at the end if file name already exists
  122. Solved: Turning multiple quantities into singles
  123. Referring to excel application
  124. Solved: Trouble looping through ranges with non-adjacent cells
  125. Automating calculations between values on 2 separate worksheets
  126. VBA knowing which cells it has filled?
  127. Combine "if" formula : help required
  128. Bulk Copy / Pasting
  129. Automatically fill cell when data entered in another sheet
  130. Macro crashing excel
  131. Please help me find out the data link of the website
  132. Subtracting Values of Range Variants
  133. Status Bar or Progress Bar
  134. Solved: Concatenation of many cells from another workbook as a “block text”?
  135. Filtering the values and removing the duplicates
  136. Solved: OLECMDID_SAVE or SAVEAS pvain pvaout
  137. Parsing an RFP Word Documnet to Excel
  138. help with code please for arrays
  139. Reset MOST of Worksheet with Macro
  140. Graph in VBA
  141. auto save workbook upon close
  142. Solved: filter bloks
  143. Solved: ChangePivotCache - PivotCaches.Create Problems
  144. How to Loop through columns in an Array and write to a range
  145. Add additional data to word document's bookmark in excel
  146. Solved: Subtotal() generates extra lines
  147. File Copying From/to different Folders
  148. Solved: Downloading File issues - Buffer Length invalid or not enough memory
  149. Text to Excel VBA
  150. How to show save as dailog box
  151. Solved: macro to read a cell and subtract a number?
  152. How can I display a list of folders and files in window?
  153. error when puting more than 1 string
  154. Help on Extract portion of string in the right way
  155. need to help: mid function
  156. Move data from Excel 2007 to Access 2007 using VBA
  157. Copying last value of a column
  158. Impoting excel sheet to new workbook
  159. date help
  160. Solved: If values in row cut/paste
  161. If the selected cell does not have a comment, then insert a comment.
  162. Ways of declaring arrays
  163. Changing Multiple For Each Statements Together with Next - VBA
  164. Solved: leave the ActiveX text box, pressing 'Enter'
  165. Data Feed to Excel using XML from a website
  166. Formating prob
  167. Select dates by current month
  168. first post....
  169. Unable to get the Vlookup property of the WorksheetFunction class
  170. VBA Nested Lookup as a UDF
  171. Solved: VBA count files funtion
  172. Solved: How to repeat a procedure/code a number of times
  173. Solved: Return which control triggered an AfterUpdate event
  174. Autonumbering invoice then saved to another worksheet in the same workbook
  175. HTML Source Code from Safari/Mozilla on mac
  176. Build a tree of called functions / procedures
  177. Adjusting array of values for filtering for actual values in sheet
  178. Saving file
  179. VBA for Updating Pivot Table report filters from a OLAP Cube
  180. Form Display stops at FormName.Show - Why
  181. Solved: Whenever cell is added will be recorded on another sheet with date and time and value
  182. Copy a cell from excel to word and aligning center using VBA
  183. how to make add-in load before workbook
  184. HTML Source from IE
  185. Solved: Delete Rows with Condition
  186. excel 2007 cell context menu question
  187. Solved: Array Not Working
  188. Solved: Get Textbox Value
  189. Help with macro to update text on shapes
  190. Solved: Select the cell with the click of a mouse, and have the result of calculation
  191. Solved: How to get Last Key or Key-Combo Pressed (Not Event)
  192. Solved: Moving files from different source folder to different destination folders
  193. Solved: Parsing Addresses
  194. Help with Macro and Object Variable
  195. Pull info from one Active Workbook and Save in Another
  196. Solved: If wb is open give message
  197. exe
  198. UK National Insurance Number Validation
  199. data conversion
  200. Solved: VBA to create a separate sheet for each month
  201. Right click option menu...specific items
  202. Invoice Processing
  203. Input difference words run difference macro in one textbox
  204. Open XML file in Notepad and delete all "-"es
  205. Solved: Hiding columns
  206. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
  207. display worksheet data in user form
  208. Convert sub to function - prompt not appearing in formula bar
  209. Solved: Print pages that contain data
  210. Solved: Increment Formula With If Statement
  211. Boost Macro running speed
  212. group data
  213. [SOLVED] Removing Duplicates for Multiple Columns independently
  214. Solved: Report to collect filtered data from multiple sheets and consolidate
  215. Hide columns based on cell value
  216. Copy from one worksheet and save to another
  217. Solved: Lastrow +
  218. Validating more than one textbox for Null values
  219. Solved: Sum particular data
  220. Solved: Simple VB? Take one file and make many
  221. HTTPS GET REQUEST ***HELP***
  222. Passing variables
  223. VBA code to send excel sheet as PDF
  224. Combining MsgBoxes into one box
  225. Userform limit?
  226. Solved: how to make shipping label with picture
  227. Find 1st Empty Cell in Range
  228. Formating (pivot)
  229. Want to create a variable that references a cell
  230. How to copy and paste the date
  231. Force ontime Macros to run one after another instead of simultaneously
  232. Solved: Move to Next Record
  233. Solved: Moving cell values based on specific criteria
  234. VBA code for Cursor to stay Stationary in one cell
  235. Automatic Calculation when sheet tab clicked
  236. SaveCopyAs not working.
  237. Urgent VBA Debugging help
  238. Concatenate string with itself in a "while" loop
  239. MultiPage in UserForm
  240. How can I change part of my title by referencing a value in a cell?
  241. Create Desktop Shortcut - Change Icon
  242. Flag on birthday calendar
  243. Solved: Macro request: Copy rows that match values in a column of names
  244. excel 2010 windows 7 64 bit hangs fooooorever
  245. Saving a file vy referencing a cell and using RDB Create
  246. Solved: Round down to nearest 5,000
  247. Solved: Cell value = #NUM!
  248. Solved: Code wont run in certain modules
  249. Solved: UserForm with ComboBoxes and TextBoxes
  250. Loop to Copy Text From Excel to Powerpoint Text Boxes